-
Pending Report - Formula Assistance Needed
Y'all... I struggle with formulas. Please help! On our sales tracking sheet, we track probability of the sale closing, expected close date, and the price low and price high of each potential sale. I'm currently using a modified version of the Sales Pipelne with Summary template. In addition to the summary (that shows…
-
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…
