If isblank question

tjf0039

tjf0039 ✭✭

10/10/22 in Formulas and Functions

Need some guidance on a formula for flagging a row if "touch date" is over 30 days. also need it to not flag if "touch date" is blank.

0 ·

Answers

Michael Culley ✭✭✭✭✭

10/10/22

How about: =IF(OR(TODAY()- [Touch Date]@row > 30,[Touch Date]@row =""), 1,0)

0 · Share on Facebook Share on Twitter
tjf0039 ✭✭

10/13/22

Ahh i was close! however i think i need to add isblank?

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

Reset sequence of number back to 1, based on date change.
I am using a column called Date, formatted as Date. My second column is called Row ID which is my Sequence column, and it is formatted as AutoNumber starting at 1. When the user fills out the Form Date and submits the form, I want the sequence number to increase the RowID By 1, starting at 1 first thing in the morning.…
Match Formula Help
I have created two sheets and in need of some help with a formula. Sheet 1: Vendor Directory (with columns "Vendor ID", "Vendor Pin", and "Vendor Verified"). Sheet 2: Vendor Verification (Which vendors will populate with their "Vendor ID" and "Vendor Pin") When a row is entered in Sheet 2 the formula should look at sheet 1…
Return results from multiple values- JOIN COLLECT HAS
I need to return data from column5 separated by comma if a record appears in column6 which is a drop down list that can have multiple values per cell. This is the formular that works only when there is one value in the cell.. =JOIN(COLLECT([Column5]:[Column5], [Column6]:[Column6], "2"), ", ") This formular gives me…