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

How can I make conditional formatting based on a positive or negative number?
I have "Budget," "Expenditure," and "Over/Under" columns. I already have a formula to calculate the "Over/Under" value. I want to have the value in that column show in RED font if it is over the "Budget" value (this will be different for each row). I tried in the conditional formatting section; however, the criteria only…
Add month in a date
Hello,I searched the forum but couldn't find any formula that worked. I'm trying to add a value (value defined in a column) to a date. I try the formula : =DATE(DAY([Contrôle effectué en]@row:[Prochain contrôle]@row); MONTH([Contrôle effectué en]@row:[Prochain contrôle]@row) + [Fréquence d'entretien]@row; YEAR(([Contrôle…
Formula to Automatically Update Red, Yellow or Green Symbols
I am having a difficult time getting the right formula for this. I would like to make it so if any of the dropdown options are selected that contain the word "Dead" then a red symbol auto populates in the column to the right. Any help would be greatly appreciated!