-
setting date parameters in cross sheet formulas
Hi, I am looking to pull rolling data onto a dashboard. i have the cross sheet formula working well however i am looking for some help with an addition to this. I would like to add to the formula to look at data for the past 30 days for one column and the past 60 days for another column. i am hoping this is pretty straight…
-
Counting party size from Symbols
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
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?
