-
Choosing a Task List vs a Project
So, I have a question that on the surface might have obvious answers but want to think through the potential implications for choosing a Task List vs a Project. In theory a Project should have a defined start and finish for all tasks. A Task List essentially becomes a "to do" list. Tell me what I might be missing please.…
-
Why won't my COUNTIF formula not count anything from source sheet?
Hi all, I currently have a system for three spreadsheets: 1) Masterlist for open/closed actions that feeds a 2) Open Actions sheet, and a 3) Closed Actions sheet. The formulas for the first two sheets work perfectly, however, when it comes to the third sheet (Closed Actions), my COUNTIFS formula will not count anything on…
-
Using decision symbols: Yes, No & Hold
Hi all, Understand that this has probably been answered before however I can't quite find the solution I need and have spent a little too long trying to get this sorted. I need to display Yes, No or Hold symbols with the following parameters: If [Status@row] is equal to "Submitted" or "In-Progress" and [Created@row] (date)…
-
Continuously evolving Sum formula
Is it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul and Aug. The rest of the year is mapped in the exact same style, but for Sep Oct Nov and Dec.…
-
Auto populate a cell when inserting a new row
Hi all, I am creating a project plan with RAG symbols. However, when I insert a new task / row, I would like the green symbol to auto populate rather than remain blank. Is there a way to show this as the green ball when inserting a new row? (Image attached). I would like to do this without a formula if possible. Thanks in…
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
IF Y is blank, and X is not, take Date of X and add 90
i know this is not correct.. but. can someone help me fill in the missing pieces. =IF(ISBLANK([Renewal End Date]@row, [Agreement End Date]7, +90)) my goal is to have the Next Review column produce a date that is 90 days from either the renewal end date (if there is one) or the agreement end date Thank you in advance!🙏
-
Can a dashboard be exported to a Google slide deck?
I would like to take parts of a dashboard and roll the data into a preestablish Slide deck
-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
