-
Bug: Comparing max(system date) to system date returns incorrect result
I'm trying to retrieve the latest created date and compare it to the date-time. I was expecting to get a date, not a date-time, and that would be OK. =MAX(Created:Created) returns 11/29/16, which is what I expected. However, comparing the [Created] column to this value returns some rows that were created on 11/28: I've…
-
Form Field to Comments
Is there a way to have a field on my form that would input the text to the comments for that row?
-
if statement
Hello, I am trying to make an "if statement" but I got no luck. I don't know how to start, I tried with =IF(sqf1 > "32", "width1*hight1*5.5", "sqf1 < "32""width1*hight1*8.5") I know its looks bad :D Thank you
-
We need Two Cells to Trigger a final cell location
We need When Med4 Quiz is checked and Med4 E Learning is checked, then All Complete needs to automatically check. I have tried =IF(AND([Med4 Quiz]3 < 0, [Med4 E Learning]3 < 0), 1, 0) ...but this is not working for me. Any help with this would be greatly appreciated!
-
How to highlight a date in a column based off of another date
Id like to highlight Column (Date Sent to Owner) in reference to Column (Due Date). If we hit the targeted Due Date, before or on the day that it is due- I would like Date sent to Owner to be highlighted green, if I we exceeded that date or it is past due, I would like that to be highlighted Red. Is this possible or is is…
-
Visual budget management
Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…
-
Drag fill across colomns
I have a sheet with 180 columns, each with a "add sum" *=sum([column name]:[column name]*. I am trying to "drag fill" the add sum across all 180 columns - but the formula does not adjust to the [column name]...any other way of doing this than typing the formula for each column? TY
-
Finding a formula
I have a formula counting the last 8 numbers in a row. I have hovered over the cell and can't find the formula to copy it to another line what am I doing wrong?
-
Using formula - Pick first day of the week
For example, today is 11/15, and first of the day (Monday) of this week is 11/13. How can I pick up 11/13? Thanks for your advice!
-
Need a way to calculate hours and minutes
We are using the hours and minutes duration option for our projects and need a way to calculate the stop time based on the duration. We enter the duration and Start Time and want Smartsheet to calculate the stop time (currently we have to enter it manually and there is definitely margin for error... not to mention time…