Discussion List
Master Out of Office Calendar Sync with Individual Project Gantts?
Hi! I manage several different projects with separate gantt charts, all with different project teams, and I struggle with cross-checking everyone's ooo schedules when I'm updating timelines. I would ultimately like to find a way to have a Master OOO Calendar that be pulled into the gantt charts based on the people assigned…
Formula Help
I have this formula: =IF(CONTAINS("Resource", [Component Type]@row), LOWER(Curriculum@row + IF([Grade/Level]@row <> "", ".g" + [Grade/Level]@row) + IF(Module@row <> "", ".m" + Module@row) + IF([Concept/Topic/Arc]@row <> "", "." + [Concept/Topic/Arc]@row) + IF(Lesson@row <> "", ".l" + Lesson@row) + "." +…
How do I share a folder which is located under the Sheets folder?
Although other people are able to see and access the folder, "DigitEYES", located under the Sheets folder. I am unable to give access to it to a new user. I can't find a share function anywhere.
List of Same Project name with unique date.
I have four column as show in table below columns. I have one text/number column two date and one duration. "I have nearly 500 projects in my database. Some of these projects share similar names, and among them, certain projects have distinct submission dates despite having the same name. I need to compile a list of…
what is the best way to combine contacts from children rows into parent row?
In a contacts column, I would like to combine email addresses that are in 2 children rows into their parent row. I have a helper column that checks a box of the children rows using the formula: =IF(COUNT(ANCESTORS([Protocol ID]@row)) > 0, 1)
Index collect from
I have 2 sheets I am working on with; Sheet #1 (POD Archive) - this is where the entries are logged. A single entry could have multiple PO's in column "PO Number". PO numbers were separated by space. Sheet #2 (POV) - contains data imported from an external application using Excel - it contains one PO number per record…
Sheet Summary Data not syncing on my Dashboard
My sheet summary data is not updating in the widget on my Dashboard. What makes it even weirder is that part of the sheet summary information from the same sheet will update, but another part of it will not. How can I fix this? Is there a known issue with this?
Unable to get the formula correct to merge my data from multiple columns into one column.
Is there a demo version where I can review document builder and docusign?
Automation Workflow Not Triggering
Hello, Does anyone have any suggestions on how to fix this issue? It seems after I've entered more data in the sheet, the triggers stopped working and I'm not receiving any emails at all. I didn't change the triggers when they used to work and only entered more data in the sheet. I've also sent a ticket to Smartsheet IT…