Using Flag Symbols with IF Statement and Form

Amy Evans

Hello,

I have a Smartsheet form feeding into a spreadsheet. In the spreadsheet, I have this formula to showcase a red flag if any form request due date that is within 2 business days.

=IF(ISBLANK([Due Date]@row), 0, IF([Due Date]@row <= TODAY() + 2, 1, 0))

I also have 2 auto-numbering rows for:

• ID - generates a sequential #
• Creation Date - generates the date/time

ISSUE -- I want copy the above IF statement on all rows so that when a new request arrives, the flag is already shown. When I do this, the auto-numbering rows populate, which I don't want to do.

Is there a way to get around the auto-numbering if I want to copy/past a formula like the above down the rows? I'm already using a the colored circles so I cannot utilize that symbol. Otherwise, I'm open to other symbols.

Thanks,

AE

Andrée Starå

@Amy Evans

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Amy Evans

I hope you're well and safe!

You can use the Column Formula feature to make sure that it always fills in.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Amy Evans

Wow, this is great! I learn something new all the time. love it!

Amy

Andrée Starå

@Amy Evans

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!