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.
how to get the formula to get the weighted average of the scrap
I have a column titled "start date" for each of my employees. I would like a reminder sent to a manager at the 30-day mark after their hire date.
Hello , I am looking for help to write a formula that will check a box if certain criteria are met. I have students that are signing up for a class and they need the previous class or classes as prerequisites. for example i have class 1, class 2 , class 3 and class 4. each higher number class needs to have completed the…
