Sign in to join the conversation:
In my project sheet I have checked boxes and flag. I would like to include them in my formulas.
Example:
If the box is unchecked by X date then the X date will appear in a reminder column.
Try the below formula replacing "Date" and "Space" with your column names...
=IF(AND(Date1 < TODAY(), Space1 = 0), Date1)
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…
I am trying to send non-Smartsheets users information on forms. I know I can create a publicly accessible and editable link for the overall sheet/form, however, when I set up automated emails with links to the forms, the links to sheets/rows still require a login. Is there any way to get around it so that emails sent…
This discussion was created from comments split from: Generate documents from row data.
