Is there a way to create a if statement that works based off the selection of a drop down list, and if that selection hasn't been made by a certain date is displays "incomplete"
Where would you want "Incomplete" displayed? To have the dropdown automatically display it, you would need to automate every option within the dropdown as you can have either automated OR manual entry, not both, in a cell. If you wanted it in a different cell, you would just need a simple IF(AND( statement along the lines of...
=IF(AND(ISBLANK([Dropdown Column Name]@row), TODAY() > insert date criteria here), "Incomplete")
I have a Smartsheet automation setup to reminder the planning to complete their sections. It is setup to remind weekly until completed box is checked. They received 2 reminders and then the reminders stopped. Any idea what could be wrong? I can't tell that anything has changed in the sheet. Thanks Freda
I'm editing formulas in a Sheet Summary. However, I'm prevented from seeing the formula by an annoying "helpful" popup that obscures my view. I can't figure out how to get rid of the popup. Does anyone know?
I am trying to create a workflow and for some reason it gives me an error with the email I entered as the recipient for my Alert. It is an email that I know works, it is shared to the sheet, and the access to the sheet is unrestricted. I am perplexed at what the issue is. Anyone else get this and know what the issue is?
