IF

Options

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

Countifs
OK - So I have a multi select cell with 4 choices (A B C D). I need to count only the cells that contain only both A & D. I tried countifs using and, contains but cant quite eliminate the counting of other combos for exampe ( A B D). Thanks in advance for any ideas.
Count if box is checked in one column and there is a specific month year in the Month Year Column
Month Year column is a text/number format. There is a space between Month and Year in the column title and a space between month and year in the column cells, ex: 07 2025 I have tried a number of formulas and am not finding one that yields the count. Here is the most recent one I tried: =COUNTIFS([Month Year], "07 2025",…
Vlookup/Indexmatch (retrieving date from one smartbook to generate in main sheet)
Good afternoon I have figured out the vLookup formula in Excel but I am having issues in Smartsheet. I want to enter a name in my main sheet (2025 OT Tracking) and then I want the Cost Center to auto-populate from my second sheet (CC&Names). I have looked at numerous formulas and I am still struggling.