-
Can't plot data eventhough I have access
Hello, I have troubles plotting the data of a certain smartsheet. I tried copying it from the smartsheet as well as recreating the chart from scratch. Nothing seems to work. Any ideas? Data source is a filtered report.
-
Multiple IF THEN outcomes based on combination of drop down values from 2 columns
I've looked through a number of formulas in this community, but can't seem to find one that works for my application. I am trying to build a Stakeholder Register sheet. Based on the values from dropdowns in 2 different columns, I want to populate a 3rd column with one of four stakeholder engagement strategies (Engage &…
-
Space to view Product Enhancement Requests
Hello, I'm new to Smartsheet and surprised to not find (at least not easily) a space to view Product Enhancement Requests submitted by other users (and soon to be myself). I've found several folks asking for certain features in community posts and they are directed to submit a form. I don't want to duplicate a request that…
-
Birthday/Anniversary Formula & Reminders
I would like notifications to send for both work anniversary dates, and birthdays. Easiest way is likely creating a date column populated from a formula and automation reminders based on that column. I currently have columns for: 1 - "Company date of hire" 2 - "Employee Birthday"
-
Sort in sheets
Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…
-
How Can I use a form to update empty cells on an existing row?
I have a sheet that will have data that changes, in this case locker assignments. I want to create a form for people to assign themselves to an empty locker, by providing them with a dropdown list of available lockers, and include if they're top or bottom lockers through logic. I don't want the people to have access…
-
How to make a secondary x-axis on column graph
Hi, I need to capture 2 catagories on the x-axis of the chart, one for cohort and one for month. Each cohort will have Jan - July months, there there will be 2 groups on the x-axis. For example, here is my sheet: and so far my graph looks like this: The months are correct but I need them grouped with a second axis for…
-
Smartsheet report cell linking not working
Hello, I am trying to edit a Smartsheet report to update a dashboard and cannot get the content to populate. I linked the correct cells into a summary sheet called Portfolio and the data is populating correctly. But when I go to pull in a specific column data from Portfolio to the report sheet called Report, the column…
-
Conditional formatting based on column date
Hello, I am trying to change the status of an action item to Red or Green based on the date it was completed. The logic in my head, reads as follows (if (Completed>EndDate)) -> RED, else Green but when using condition formatting , its not allowing me to select the EndDate column, instead its asking me to put a specific…
