User Profile
Brian_Sarpy
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Calculated Column to populate an Alert
Hi everyone! I have been trying to do a formula that will show the words "PoP Alert" if Todays Date column is less than or equal to a column titled "Alert Date (Do Not Touch)". I am also trying to add in the formula that if the "Alert Date (Do Not Touch)" column is empty or contains the word "Expired" that it leaves the column blank. Below is the formula I am using but it keeps saying something is wrong with the formula. Any help would be greatly appreciated. =IF([Alert Date (Do Not Touch)]=”Expired”,"", IF(ISBLANK([Alert Date (Do Not Touch)]),"", [Alert Date (Do Not Touch)]<= [Todays Date (For Formula Only)],”PoP Alert”),””)1KViews0likes2CommentsNeed Help with IF Formula in Calculated Column
Hi everyone! I am hoping you can please help me. I am calculating a burn rate in a SharePoint List in a calculated column (titled Burn). I am trying to return a blank value in the Burn column if the Funding Remaining column is blank or if there is an error in the column titled Burn. Below is a brief description of the columns I am using. Funding Remaining Jun Invoice Jul Invoice Aug Invoice The below formula works fine if the funding remaining column is blank, but I have tried to get rid of the errors (predominantly brought on when the trying to average the Jun, Jul, and Aug invoice columns) when they are blank. =IF(ISBLANK([Funding Remaining (As of last invoice)]),"",[Funding Remaining (As of last invoice)]/AVERAGE([Aug '23 Invoice (Est.)],[Jul '23 Invoice (Est.)],[Jun '23 Invoice (Est.)])) Any help you can provide would be appreciated.Solved1.1KViews0likes2Comments
Recent Blog Articles
No content to show