-
Date changes to tomorrow after 5pm
Hello, I have been trying to find a work around for an issue I am having on sheet we use. We are currently using a sheet for employees to submit when they check out and check in equipment via a form. We were using the auto created date column to run reports on what equipment were checked out vs. available. We discovered…
-
Multiple Countifs and Children to use in a Dashboard
Hello Everyone! I'm new to figuring out counts in SmartSheets and Dashboads/Sights and could use a little help. I have a sheet that is connected to Salesforce via the Salesforce Connector, so the data is dynamic. I currently have the sheet grouped by department. Under each department are children rows for projects. There…
-
SumIf contains certain text--use FIND?
Sorry, I tried to search the archives but couldn't follow the examples so am hoping someone could help me with this specific scenario. I am trying to put together a budget that is summing up columns that contain certain text. I would like to figure out how to sumif Row 3 all columns containing the term "grant" so that I…
-
formula help
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 that relates to other fields and is a check box. if true then tick the check box. i am now wanting to sum the value of all…
-
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…
-
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…
