-
Account Color Palletes
I would love the ability to add a larger org color palette that is applied not just to new sheets but dashboards and reports. Being able to add the entire companies palette across all items would also help reduce time in creating by not having to manually have employees add the palette. I have already set up my company's…
-
Welcome to Just for fun - let's post some memes!
Hey everyone, welcome to the Just for Fun Topic (formerly known as a Category) which is just that - a place for all of us to take a breather and have a laugh or two. To start, let's go with the Internet's chosen love language: Memes. What's your favorite Smartsheet meme? Drop it in the comments (keep it clean please!).…
-
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.
-
Formula
I have tried multiple formulas. I am trying to count how many "Assigned" are "Status" (completed, not started, In Progress). I am trying to do this by the person in The Assigned. So, Angie has (2 Not completed, 3 In progress). Can someone help with this.