-
countif help
Hi Folks hoping i can get some assistance I have a large tracker that is tracker COVID isolations and test results. i have made a "Summary" sheet that is designed to create a value to display defined information on a dashboard I made a Weeknumber helper column, the week number will generate if - Positive is checked and…
-
Two new PPM Functions: Successors and isCritical, available now!
Hi Community, We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical. The Successors function (type: numeric) allows users to calculate the direct successors of a task and return a collection of values that will occur as a result of the referenced task.…
-
Issue with Index Collect Formula
Looking for help! We collect form responses that load onto this sheet below the KPI section. I need to see, at a glance, TODAY'S responses in the Reporting Data section. So I'm using an INDEX COLLECT formula to pull in today's response from each team member. However, I am getting the errors as shown below. I simply want to…
-
How can I convert text names to existing contacts in my account?
I manually imported an Excel file into Smartsheet that has hundreds of names as text (no e-mail addresses) which I'd like to use to pull existing contacts in my account. The first and last names match to what's in my account. I've changed the column on my sheet to 'Contacts' thinking I'd be able to leverage contacts in my…
-
Formula to count a value within a given range
I am trying to write a formula that must meet (2) criteria and then count the number of values that are: <500 =500 and <=999 ( this is the formula I cannot write for some reason) >999 I have been successful at pulling the two criteria but cannot figure out how to add the count in the formula. I set them up and can pull the…
-
Question on Value function
Hello. Using this formula, =IFERROR(VALUE(LEFT([Time to Close (Bus Hours)]@row, 3)), IFERROR(VALUE(LEFT([Time to Close (Bus Hours)]@row, 2)),VALUE(LEFT([Time to Close (Bus Hours)@row, 1)))) I'd like to be able to take a string that contains hours and minutes, separated by a decimal point - for example 259.04 would give me…
-
Formula to count days past due but leave the column blank if the task is completed
Hello, On my sheet I have tasks that have a column for Due Date, Completion Date, and Checkbox for Done. I want to keep track of the tasks that are overdue and have an easy way to glance and see how many days they are over due from the due date. I have been successful in using this formula for that calculation =TODAY() -…
-
Identify deliverable date at the parent level
I'm using these formulas to show the next milestone date: Milestone checkbox column: =IF([Expected Finish*]@row = MIN(COLLECT([Expected Finish*]:[Expected Finish*], [Expected Finish*]:[Expected Finish*], >=TODAY())), 1, 0) Next Milestone Date: =MIN(COLLECT([Expected Finish*]:[Expected Finish*], Milestone:Milestone, 1))…
-
SUMIF - Referencing another sheet
I'm trying to sum based on certain Streams(column name) in another sheet 'Register' Stream data is as: Emergency Youth The formula I've used is: =SUMIF({Register Range 3}:{Register Range 3}:, "Emergency") I'm getting an unparseable error Please help!
-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)
Hi All, I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Service 2, PM Service 3, Oil Change, etc.). For my source sheet, I'm using a repair and…