-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Highlight Colours
Hello, I have an 'Alerts & Actions' when a row is added to email out many cells. When this email arrives in my staffs inbox the cells are bright yellow. Is there a way to change the colour? - I would ideally like a less bright colour? Any help would be wonderful. Thanks Matt
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Nesting SUBSTITUTE functions
Hello All, I need help!!! I am trying to write a formula that replaces the letter "a" with the number "1", "b" with "2", "c" with "3", etc.... The individual formula of (ex.) =SUBSTITUTE([Column3]1, "a", "1") is easy enough, but for whatever reason I can't seem to figure out how to nest it with the rest of the letters and…
-
Having link to Smartsheet on our intranet
Hi all! I work in the Communications department and we keep a tracker of all of the events for the year. It used to be an Excel spreadsheet and we put a link to it on our Intranet page for all staff to access. Now we keep it in Smartsheet, and I've only given access to my team. Is there a way for folks outside my…
-
Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it. However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go…
-
Error message - publishing SmartSheet calendar to Outlook
I played around with the publishing calendar functionality using ICal and syncing it to my Outlook account. I eventually decided not to use this function and turned it off in SmartSheet. Several times a day I am getting an error message in Outlook related to publishing the calendar. See the attached screenshot. Any ideas…
-
Children not displayed
I have a list of that will not open up today. There are 671 children and the "+" and "-" changes but the rows are not displayed. Help please! Rose
-
Format key and Primary Column
Hi all! I have two questions: 1. I have several conditional formatting rules that change colors or font based on contents. Can anyone recommend the best place to put the "format key" to indicate what each color and font means? I currently have it in an attachment, but that's not so easy to reference. 2. Does the Primary…