-
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…
-
IF(AND) Function: Invalid Operation Response
Hi All, I'm trying to implement an IF(AND) function within my sheet that is dependent on a number of other conditions on sisters sheets being true to display a string and if false, a separate string. My formula is this: =IF(AND({Experiment Tracker Range 3} = "MEMS 1", {Experiment Tracker Range 4} = "1", {Experiment Tracker…
-
Conditional Weighted Averages
Hello, I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved. The column "Status" can also be Pending. The function SUMIFS works great if you don't need to do the weighted average. Is there a preset function or…
-
Please help with an a SUMIF formula
I have a spread sheet with a column (with a formula) that counts how many days it took for each project to get from one department to the next. I am trying to figure out a formula to add all those days together but just from a specific month in 2018... I will eventually have to do this for each month for the next couple…