-
Can't create an X-axis on a scatter plot
Hi there. I want to make a scatter plot that graphs points based on the following two pieces of data: impact score and design hours. My issue is that I can't get the X-axis to display the content in my design hours column. Here is a picture of my scatter plot. The dark blue points at the bottom of the Y-axis shouldn't be…
-
Unable to Update Profile Data in Control Centre
Hi, when I create a new project in Control Centre, I get this error message just for this one column. I reference this field the same as every other field. It USED to work and stopped working about a week ago. Any ideas why just one field will not update to my Metadata? I have triple checked spelling and spacing. Thanks
-
Pulling values from a dropdown list
I have a dropdown list (allows multiple values) and I want to pull the values and present them in a text field separated by a comma. For example: My list is Item 1 Item 2 Item 3 and I want to pull them in display them as "Item 1, Item 2, Item 3" Using this formula: =JOIN(COLLECT(Category@row,Category@row, <>""), ", ")…
-
Schedule Summary
I have a sheet that has a full project schedule on it. The tasks and dates are in rows. I would like to get a summary of several rows for a client. What is an automated way to do that that can stay up to date as I update the schedule?
-
Dates are formatting in 2 different ways on the same sheet
Is this a Smartsheets bug? My formula is simply concatenating the date with the time. This seems to happen randomly when smartsheets updates itself, and it fixes itself only when I re-save the sheet. Our Windows OS date settings are set to American format mm/dd/yyyy, but our smartsheets are set as dd/mm/yy Is there any way…
-
Workspace Attachments vs File Library
what is the difference between attachments added to the workspace attachment summary and attachments added to the file library? What is the indicator to an end user that attachments are available?
-
Visual Status Alert
Hello All! I hope this is an easy soulution. Can anyone assist me with creating at status alert based off of today's date and a start date? I want the Delay Status to automatically put the status listed and color the cell. If a Cleard to Start has a check mark, then it shows no delays and color coded green. At some point,…
-
Exact
I just want to compare 2 cells (=exact in excel) if they are exact then true, if not then false, why am I struggling
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.
-
Total number of inquiries is off by one
I am fairly new to Smartsheets and racking my brain trying to solve this problem and I am hoping the community can help! I have a log sheet that we use to keep track of inquiries received through one of our channels. I have the 'Inquiry type' column, that has the multiple dropdown option for all the different types, and…
