IF

Mike P

Mike P ✭✭

01/16/24 in Formulas and Functions

Hi all,

This should be so easy, and yet, I keep getting it wrong!

I would like to automatically put a field that says "Archive" is I mark the previous field in the row as "Complete".

Any suggestions?

IF question.JPG

Thank you,

Mike

0 ·

Answers

Mike P ✭✭

01/16/24

Here is the screengrab

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

"Boolean Expected" Error
Hello All, I spent a few hours building an equation (I am not an expert) within a sheet that reads another main sheet. =IFERROR(INDEX(COLLECT({GenFertCalc}, {Client Name}, [Client Name]@row, {Tones}, "Granular Fertilizer (Tone)"), 1), 0) The error message "Boolean Expected" occurs in the correct cells, but instead of…
HELP!! Needing to subtract just one from this formula
I have this formula for a total count! I just need to subtract 1 from the formula This is what I have and it is showing Unparseable ="2021-2022 Total Contracts: " + COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2022, 12, 31)))-1)
Hello! I am trying to make a graph with these dates!
I am using a Grid Sheet and a reference sheet but can not figure out how to get the formula to match. I am using =COUNTIFS([Start Date]:[Start Date], AND(@cell >= DATE (2021, 1, 1), @cell <= DATE(2021, 12, 31))) This is my reference sheet formula =COUNTIFS({OnBoarding Partner Agreements Range 1} [Start Date]:[Start Date],…