Formulas
Discussion List
- i need help with a formula please. my current formula looks like this.. =SUMIF(Stage:Stage, ???, [Job Value]:[Job Value]) i need an answer to the ??? please as it is a column that has a formula in it …
- Hi everyone, I have a smartsheet where each row represents an "installation". One of the columns is called "Gone Live" and is of a type checkbox. I have created another column entitled "Number of Inst…
- Hey everyone, working on something that i am having a problem with I have the following =SUMIF({FSM - Help Desk Ticket Tracker Range 4}, $VlookupValue@row, {FSM - Help Desk Ticket Tracker Range 1}) Th…
- Hello, I have the following formula to calculate % Over/Under Budget: =[$ (Over)/Under Budget]8 / [FOOD BUDGET July 2018]8 I would like this to work even when there is a 0 in the Budget number and eve…
- 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 …