Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
How do you structure your formula calculate negative if it is over 100%
For example, I am at 144% which is over budget
Current Formula =AC1 / [Project Budget]1
Results 144%, I would like it to calculate -44% once I am over budget.
Hi Kam,
=IFERROR(IF(AC1 / [Project Budget]1 >1, 1 - AC1 / [Project Budget]1, AC1 / [Project Budget]1),"")
This should do what you're looking for. I threw an IFERROR in there so you didn't get an error result if the values were blank.
Kind regards,
Chris McKay
Thanks!
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
Does anyone know how to revert a sheet to a prior version after a column formula resulted in replacing all of the values with #circular reference? Would all entries have to be manually re-entered?
