Sign in to join the conversation:
Hello,
I was wondering why the formatting of this document is auto-crossing out the actual calculation? Is it suppose to be doing this? Is there a way to make it not do this?
Someone likely set up a conditional formatting rule on your sheet. You can disable it with the steps in our help center: https://help.smartsheet.com/articles/516359-conditional-formatting#deletedisablerules
If a conditional formatting rule isn't the cause of this, it's likely that some cells were formatting this way, and the formatting is auto-filling to new rows. To fix this, select all of the cells that have this formatting, and click on the format eraser (eraser looking icon) in the left toolbar. This will remove all formatting, but will keep your formulas/values in tact.
Hello, I'm using a SUMIFS formula to try and get the sum of materials, done during a specific process, during the specified date range of May 04 2026 - May 08 2026. But it continues to total all entries in that column, instead of giving the total based on the provided data. I've also tried using both OR and AND functions…
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…
