-
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…
-
Delete task dependency
I'm trying to delete one task dependency on a Gantt chart. I found this quick YouTube video, which says to click the dependency line, but I'm unable to click on it. My dependency lines are not green like in the YouTube video. Thoughts?
-
Does anyone have a grant/program management template to share?
I need a template that will help my team track relatiosnhip management, and grantee relatiosnips- especiallly regarding grant milestone progress.
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Formulas in Columns with Dependencies?
Is there any way to work around dependencies in columns when entering in formulas?
-
Attachments oddity
Good afternoon, In looking for a particular attachment, my result took me to the "Attachments" tab on my sheet. However, that attachment is not on any row in my sheet (I physically checked each of the 300+ rows in that sheet to verify). Curious why that tab shows far more attachments than what are actually attached to…
-
Automatically Generate Decision Log from Action Item List
I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…
