-
COUNTIFS with an AND
I am trying to use a COUNTIFS formula with an AND. I need to account for two different conditions to determine the count of another column. COUNTIFS the Master - Project Status column is not "complete" AND Master - Sales Stage is "Won" should return a count based on Master - Service from a row. =COUNTIFS({Master - Project…
-
Please add page breaks option on Smart sheet dashboard
This is seriously time consuming, making smart sheet not smart anymore. Every time we create a new project setting up the page for print outs is really cumbersome and time consuming, we need to check the page breaks on the preview tab prior to finalising. Add, a page break option based on the paper size chose for print…
-
Adding New Task After Setting Baseline
Smartsheet Community: Once The Baseline is Set. It Would Be Nice to Have The Ability to Add New Tasks and for those Tasks to be Added to The Baseline without Re-Setting it. Today, I have to Manual Change All the Dates. This Drastically Increase human Errors and is Very Time Consuming.
-
Merge cell functions
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
-
HELP What am I doing wrong in this formula?
=INDEX(COLLECT({Unit/Manager List WI Range 1}, {Unit/Manager List WI Range 7}, [Area of Study Parent]@row, {Unit/Manager List WI Range 8}, [Area of Study - Nursing]@row, {Unit/Manager List WI Range 9}, [Area of Study - Radiography]@row, {Unit/Manager List WI Range 10}, [Area of Study - Rehab Services - PT/OT/ST]@row,…
-
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
-
Hi There, I have a column with comma separated strings. How to find the occurrence of each string?
Please see the below table. I have 20,000 responses. I need to find out how many times each response was given. I have 20000 responses. I need to find out how many times each response was given. Thank You.
-
IF Formula to assign a symbol depending on where a date is in relation to today's date.
Hi, I'm looking for a formula to indicate where a specific date in one column is in relation to today's date. I have the column where this formula will be input setup as a symbol column to return a color (Red, Yellow, or Green) to indicate the relation between today's date and the date in another column. If the date is in…
-
Reduce Emails! Please Tweak New Assets Ownership Logic
Can you please make a slight enhancement to the new Assets Ownership Logic? To be clear, our team is in favor of the new Asset Ownership Model – it makes sense and ultimately is a good thing. That said, our team (30+ people) is dealing with an influx of emails because every time an individual requests access to specific…
-
convert 12 hours time to 24 hour time
Hi, I want to convert 12 hours of time to 24-hour time; kindly help me with this issue.