-
How to create an auto incrementing number based upon checkbox
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 Installs this year". In this column, I want to create a formula that checks the "Gone Live" field, and if the checkbox is…
-
SUMIF IF referred sheet/column ISDATE
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}) This returns the value from the cell that i want to perform a specific calculation. I want to add more to this though. The…
-
Divide by Zero error
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 even when "over/under" is 0. Thank you for your help. Todd
-
Bug: EXTREMELY bizarre behavior
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 time. And then the KPI's I was working on went 'bonkers' and I noticed the attached values coming from a calculation on a cell…
-
Detecting Cell Changes, Modifying other cells on update.
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 entry of dates of completion. I've thought about entering the following formula in a date cell: =IF([% Complete]2024 = 1,…
-
Importing Excel formulas "#UNPARSEABLE"
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.IFS([Growth %]1<0.2,1,[Growth %]1<0.4,2,[Growth %]1<0.6,3,[Growth %]1<0.8,4,[Growth %]1<=1,5) What the formula dose in Excel…
-
Counting the number of row with dates
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 would like to get a count of the number of jobs that are still outstanding from each previous month and i am not sure how to…
-
Risk Assessment
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 you could share template with me :D Marie
-
NETDAYS is giving wrong result
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 absolutely fine.
-
Using COUNTIFS across multiple columns for one criteria
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 limiting to those projects with a status of "In Progress" (Range 1). The other four columns are columns that I titled, Project…
