-
If Statement Formula Unparseable
Anybody able to explain why the following formula is coming up as #UNPARSEABLE =IF(AND(ISBLANK([Contractor CO Submittal Date]@row), ISDATE([Company CO Response Date]@row), [Company Response]@row = "New CO to Contractor"), "Contractor Response Needed", IF(AND(ISDATE([Contractor CO Submittal Date]@row), [Contractor COβ¦
-
Resent Request for Approval
Is there a way to send a reminder to someone who received an automated request for approval? I have program chairs who are either not responding or are not responding in a timely manner, so the Approval Status remains "Requested". Right now, I reset the status so it triggers the automated request for approval again. Itβ¦
-
Linked Cell Format Issue
Hello everyone, I have tried looking for this topic, however, I can't seem to find anything. I have a source sheet with dollar amounts and the cells include a number such as $100,000.00. When I link the cell to a new sheet, the number shows up as 100000 Any idea how to fix this? Thank you. Sincerely, Diego
-
Dashboard on a Rollup Sheet
We have multiple projects in a sheet and created a rollup sheet to track all of these sheets. How do we create a dashboard on top of that sheet?Β
-
Has anyone found workaround today() doesn't involve zapier
We want functionality where "Milestones missed in Last 30 days" are highlighted. We can identify Milestones. What functionality do we use to count the rows that have missed the milestone? I've seen responses about Today() function having a daily-touch limitation.Β I'm looking for the exact Logic to get Milestones missed inβ¦
-
Resource View from more than one field.
As suggested by SS, I have a Assigned To field for a task lead (set for only one value allowed) and an Additional Resources field which allows more than one contact to be included. When I create a resource view, it seems like it is only pulling from the primary field and not the additional field. Anyone have a work aroundβ¦
-
Enhancement Request -> Transfer license & Sheets at same time
I just encountered a situation where I wanted to transfer a license and sheets at the same time, and was unable to do so without a workaround. I had to either get the person to transfer all their sheets to me, then change the license, and switch them back to the new owner, or take a license away from another user, give itβ¦
-
Automation Alert Someone Email subject
Hi all, Currently, when setting up an automated alert to someone, you can customize the message by entering the email subject/body. Right now, you can only enter free text in these fields. I was curious if you can set the email subject to fill in what was entered on an field on a form. I'll add a screenshot to clarifyβ¦
-
Update requests to more than a person
Hi all, I have a spreadsheet that has set up an "Update request". Now, that same update request was set up to notify both myself and my colleague (since i was on annual leave recently, so nothing was getting left behind). What happens is, since there are 2 people in the automation, the update request only gets clearedβ¦
-
IF AND Function
Dear Smartsheet Wizard, I'm trying to create a function but I'm running into an error. The IF - And function I'm creating basically needs to do the following: If salesperson 1 is = "Yan" then deduct 100 from Profit and his commission should be profit*0.5. Otherwise, deduct 100 from Profit and commission should beβ¦
