-
Populate a cell with today's date when status is marked complete
Hi all, We have several task schedules that people use to track the status of their work. When the task is finished, they change the Status to Complete and the Percent Complete to 100%. We would also like to know the actual date the work was completed to compare it to the Due Date (which is referenced from another cell in…
-
Long Decimals - 7 digit decimals
Good morning, I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes…
-
Trigger Move Automation
I have a automation that is not being triggered, here's the setup: formula to number the time a value appears (1, 2, 3, 4, 5, etc) in the Duplicate column Move Row automation triggered when there are any add/changes and Condition a. Duplicate is one of 2, 3, 4, 5 b. Duplicate is not 1 c. Duplicate is equal to or greater…
-
Multiplying Cells in an IF statement
Morning Smartsheeters.. Was hoping someone could shed some light on why this statement isn't working.. =IF(Part75 = "Labour", [Supply Price]75 * [Quantity]75) I'm trying to multiply two cells based on whether the labour cost is Labour, or Labour O/T.. but I'm getting an INVALID OPERATION FAILURE. Thank you.
-
SUMIF formula that calculates the criteria between a number range
Having a blank mental moment. I am trying to create a sum if formula to total all of the "medium" priorities using a range of numbers. High is fine as i just did a greater or equal to (>=) and likewise (<=) for the low. When I get to the medium priority, I can't work out how to do an "in between". Below is a screen shot of…
-
COUNTIFS/SUMIFS for multiple column criterias
Hi, I have been trying to find the answer to my question on other Smartsheet community posts but no luck so far hence this question - how do I SUMIF/COUNTIF when there are multiple conditions to look at? Basically, I am trying to find all instances of the value "2 - OPPORTUNITY FOR IMPROVEMENT" in a column when the Site…
-
CountIFs
Hi I am trying to do a count if to see the following if the value selected is Milestone and the status selected is Complete at the moment I have tried this =COUNTIFS(Value:Value, "Milestone", Status:Status, "Complete") but its returns an unparsable or circular ref and the also blocks the formula I have to see the total…
-
Combine a column from two different sheets ="Complete"
I am attempting to take info from a column from two different sheets and combine the total. The formula I am working with to perform this for a single column is: =COUNTIF({Project Plan - Project A Range 1},="Complete") I tried using the following: =COUNTIFS({Project Plan - Project A Range 1}, ="Complete", {Project Plan -…
-
Formula to sequentially Number an item
I have a list of values and would like to sequentially number how many times it appears with the ultimate goal of identifying values greater than 1 to trigger a workflow to Move to a new sheet. Here's an example for reference: if Name and Week are the same, then sequentially number in Number# Any help is appreciated.
-
Auto-Number generated for parent/children rows
I am trying to build up a WBS and would like set a number generator to auto ID the various levels (control accounts and work packages). I would like to have the parent row, or control account, have an ID of 1.1 and the work packages, or child rows indented from there, to have an ID of 1.1.1, 1.1.2, 1.1.3, etc. Being a…