Sign in to join the conversation:
Is there away to get smartsheet to recognize scientific notation in order to add, subtract, multiply, divide, etc..
Thanks
Hello,
We currently don't have the functionality to interpret scientific notation within Smartsheet, but please feel free to submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.
What I am trying to do is Helper - Duration = Actual start date. So, for example: 14Apr2026 - 22d = Actual start date. Is this possible? Note: I need to keep dependencies turned on.
Any one have issues with suddenly not being able to edit formulas? I am admin and owner of the sheet one other admin has access to sheet and no locks have been placed on the cells.
I am trying to find the next upcoming Date and its associated Task based off what activity is being performed and where it's taking place. The formula I have to find the next upcoming date works perfectly: =MIN(COLLECT({Date}, {Date}, >=TODAY(), {Activity}, ="Activity ", {Area}, ="Area")) My problem is trying to get the…
