Formulas
Discussion List
- After the release a little while ago, the first thing I noticed was a simple sum of 7 cells was giving the incorrect value. That resolved itself when I closed and reopened the Sheet for the second tim…
- Hey guys. So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur. The goal here is to automate the …
- When trying to import Excel including following formula: =IFS(J3<0,2;1;J3<0,4;2;J3<0,6;3;J3<0,8;4;J3<=1;5) I get and error message in Smartsheet. #UNPARSEABLE" Following show up in Smartsheet. =_XLFN.…
- I have been asked to provide some stats on the number of live and outstanding jobs that are due. The due dates for each job is the last day of each month (30/06/18, 31/07/18, 31/08/18 and so on). I wo…
- Hi All has anyone successfully made a risk assessment template within smartsheet ? Im not able to get normal excel formulae to work ( also the templates posted on smartsheet dont work ) appreciate if …
- The NETDAYS between 5-Aug-2018 and 9-Aug-2018 is coming as 36530. I don't know what's happening - can anybody help? =NETDAYS([Last Date Entered]4, Today4) The same formula in another sheet is working …
- Hello All, I hope you are all doing well. I'm trying to use the Countifs formula by referencing our Portfolio Project sheet. I'm using five columns. One column is the project status which I am limitin…
- I'm trying to use a formula to set a symbol column's (RYG Balls) cell color value based on a date cell, however, if the cell color has been manually set to Green I don't want the formula to do anythin…
- I am trying to populate an Actual Start Date field with the current date when a checkbox is checked (Task Started). I am using the TODAY feature in my formula for my Actual Start Date. But what I am s…
- Good morning, I have been using a formula to assign a fiscal quarter to a row based on a date in another cell. I realized yesterday that the formula isn't working properly. This is the formula: =IF(IS…