how can I add IFERROR to this formula
=WORKDAY([Start Date]140, 15)
I tried =IFERROR(WORKDAY([Start Date]140, 15, ""))
and it didnt work
Try:
=IFERROR(WORKDAY([Start Date]@row, 15), "")
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
Hi, I am trying to add logic in details panel, to make few fields as read only, when Reviewed? column is "Reviewed". I'm not able to save this logic after I created. Am I doing anything wrong? Please help me 😐. Thank you!
Hello, I need to send an alert out the last Wednesday of every month. This is the easy part because I use the 'repeat' and 'repeat on' selection in a custom recurrence. My question is when to start: do I start on a last Wednesday? ie. start today 4/24? Or is the start date irrelevant, because the automation knows it should…
Help shape the future of Smartsheet. Share your ideas and feature requests.