-
emailing a form once a checkbox has been activated
Hello out there in smartsheet land, I'm trying automate an email of a survey form. I want the form to be emailed once a check box has been checked off. I've checked the formulas page and I cannot find the help i need . Any help would be greatly appreciated. thanks Donny
-
Project budgeting
Hi I'm maintaining a project budget sheet but i am having a problem with a formula i have applied same formula to all columns but last column is not being linked to the total formula bar. I am using the formula =sum(children()) for all columns, can you assist me in figuring this out
-
Formula to Calculate all screening dates in last 7 days and last 30 days.
I am seeking a formula that will calculate all dates that occurred within the last 7 and 30 days...based on the "Screening Date" column...and should not include weekends if possible. Thank you
-
Automate High formula
Hi, I am trying to automate a trigger that looks at a WBS and if it has a High Status in the form of a ! mark, that it in turn auto triggers the some status in the top WBS name line. See attached screenshot. Thanks Cathy
-
Using multiple functions in a formula
Hi, I am using a formula to determine "Planned % Complete" based on start date/end date and todays date. The formula I am using is; =(MIN(TODAY(), Finish1) - Start1 + 1) / (Finish1 - Start1 + 1) I want to nest the following formula so that if the start date is AFTER todays date, the "Planned % Complete" will be zero;…
-
Compare Date in [Start Date] to a value in a text/number column
I need to compare the date value that is in the Start Date or End Date to a date value that is in a text/number column. When I compare the two, I get "#Invalid Operation." If I change both columns to Date columns, it works, however that does not work well with my spreadsheet. Are there any tricks to doing this? Thanks
-
##Help ME please "i can t continue to work" SumIF##
I post a problem 2 days ago some response but still doesn t work, new to smartsheet but my work is blocke now problem Hello @Craig and other Helpers i experiment the same issue than other sorry for my english but i m french i copy your formula below and try to adapt with "laserjet" type i want to make a sum if a name…
-
Cash Flow Projection in Projects Sheets
Hi, I am using =IF(AND( ... )) to project in which month a disbursement will be made in a project planning sheet. Does anyone use an easier faster way of scheduling disbursements and depreciation? Regards
-
Quarters in fiscal years formula
Hey all, I'm trying to write a formula that will return the quarter and fiscal year (FY) of a given date. Our fiscal year is October - September. So for the first quarter, the FY doesn't match the calendar year (CY). So far I've been able to execute this for one CY, but if I try and add a second CY, I get back a blank…
-
Nested IF Statements
Brand new to SmartSheet. Looking for best method for nested IF/THEN statements to provide status. Or alternate methods. Example... IF column N has any value, THEN column B shows Status 1, IF column O has any value, THEN column B shows Status 2, etc. My nested IF/THEN statement from Excel didn't import.
