-
Looking For a change Order Template that is fill in and can add photos or media
Looking For a change Order Template that is fill in and can add photos or media
-
Date Formula
I am having trouble converting this excel formula =TEXT(C7,"mmm-yyyy") to the Smart sheets equivalent. Can someone help me?
-
is there a way to make children auto-calculate percent complete based on start/end date and the curr
I'm new to this program but not scheduling in general. Is there a way to get each child beneath a parent to calculate % complete automatically, based on the entered start/finish dates and the current date? I'm building construction schedules, and don't want to have to manually update huge amounts of child rows, especially…
-
Static Date/Time Time Stamp formula
I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day. =IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 = "SERVICE COMPLETE"),…
-
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…
