-
Process Duration
I'm looking to find the change in process duration before and after a process improvement project. I'm asking for the length of 1 unit of work both before and after a process improvement effort (in Hr:Min:Sec.) What I need is the change. I've tried a simple subtraction formula, but it doesn't seem to be working. Thoughts…
-
Countif formula
Hello I have a sheet that tracks number of days we are over or under staffed with a -2, -1, 0, 1, 2 I would like to add a criterion that it only counts the days that are after today. Here is the formula that was recommended by Smartsheets =COUNTIFS($[U/O Monday]$6:$[U/O Friday]$58, -2, $[Week Of]$6:$[Week Of]$58, @cell >…
-
Enter duration as "Net Days" but still count work days without Sat/Sun.
Under project settings I want to make Saturday and Sunday as working days so "Hard" products would follow a timeline that includes weekends. A task starting on October 1st with a duration of 31 days would end on Oct 31st. I also want to count the number of weekdays (exclude Sat/Sun) between two dates so I calculate total…
-
Formula Text
I am using this formula and everything looks okay but the text that shows up for "Delivered Early" is showing up in the field as 0Delivered Early. I don't know why. =IF([Days Late / Early]3 > 0, "Delivered Late") + IF([Days Late / Early]3 = 0, "Delivered On Time") + IF([Days Late / Early]3 < 0, "Delivered Early")
-
Random discontinuation of formulas in sheets
HI all! I have a several sheets with formulas. Normal, as almost every user of Smartsheet. I wonder if anyone else has the same issues with formulas as me. Sometimes, for long time my formulas are copied automatically from row to row without any problems, but randomly, without any reason system stops doing this and I have…
-
Request: Allow cell references from different sheets
I'm really enjoying the powerful abilities of Smartsheet, and especially the ways in which it's more flexible than Excel. I have to say, though, it's getting more difficult to accept that formulas just can't reference data from other sheets. This is particularly frustrating when you consider the powerful functions that…
-
Equipment Check-out...
Has anyone implemented a sheet for use as an equipment check-out form? That is a web form that is filled out by the user which allows them to select from a database of available equipment and indicate the length of use in days? I think I could do that with a column dropdown list populated with the items that are available.…
-
Cell amended date
Is it possible to write a formula using the date that a cell was last amended?
-
IF Function and Checkboxes
Hi, I am currently working on a project where I will have multiple check boxes on a row where each checkbox is going to of different values (true/false). I need a formula that will look over the checkboxes and only give me the value of the selected checkbox and then with this the value of that cell with be presented at the…
-
Nested IF/AND formula
I am new to smartsheets and I am having a hard time with a formula, hopefully someone can help me. I am trying to create a formula that will indicate the status of a task based on the following condition: * whether the task is completed or action is required * whether the task is at risk or not To conclude this is what I…