-
Looking for a formula to create a unique key
I'm looking for a formula such as MD5 to create a unique key where one does not exist naturally in the worksheet data. When combining two or more columns a unique value is possible, but it would be great to have an formula to calculate a representative vale.
-
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!