-
Formula for status update using number of workdays until finish
I need help with a workday formula. I'm trying to get my status bubbles to update automatically based on the number of days until task completion. I've got it to work counting backward using all days with the formula below, but I can't figure out how to only count workdays. Any help is appreciated. =IF([% Complete]@row =…
-
How to Record and compare previous status (stoplight color or dates)
I have a report I'm trying to emulate in Smartsheet. The report has critical milestones in column a, and stoplight colors in Column b, and c. Column b shows the prior week and Column c shows the current week. The intent of the report is to show if a milestone has trended the same, improved, or gotten worse by comparing the…
-
Calculating lost hours between dates
hello I wrote a formula to calculate the hours lost on a product cell due to down time, it meant to calculate 8 hours for a day but it counts 16 hours if the cell stops for a day as it counts starting date and closing date as 2 different days instead of just one single day down. I need to count 8 hours is the event closes…
-
Countifs with reference to another sheet
Hello, I am trying to use the following formula: =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,"]) and =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,") but it keeps coming up as "UNPARESEABLE."…
-
Date 6 months out (to the day)
Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also new at SS, so I am just now learning syntex, etc., regarding functions and formulas.…
-
Calculating Duration Between Two Dates
I'm trying to calculate durations between two dates. Would like to calculate days between: Date Submitted and Date Assigned to be calculated in a (Days to Assignment column) Date Submitted and Date Completed to be calculated in a (Days to Complete column) I don't want or have a need for predecessors or durations and those…
-
Programming with Smartsheets
Is there any way that I can use external programming to effect my Smartsheets. Is there an API that would let me right seperate programs to control my Smartsheets?
-
Changing an auto-generated number in a cell
Hello, Is there a way to override, or edit, an auto-generated number? I have an intake project sheet that generates "Job #" as new requests come in from a form. Recently a 'new' request was submitted through our form, giving that request (or project) a new auto-generated "Job #". However, this request isn't actually new,…
-
Formula
I am working on a sales report and need to total sales to dealers by month in a separate column. I have added a checkmark cell that identifies dealer sales. So if there is a checkmark then the value in grand total purchased needs to be summed for all children on the monthly sales row. Thanks for the help
-
need help with an IF function
Hello community, I am trying to come up with a cell formula that is a simple difference function, but I need it to be triggered by the number in another cell. It is for an inventory/ordering sheet. Someone will count the inventory and type in the "QTY ON HAND". there is also a column for "MINIMUM QTY NEEDED" which is…