-
How to build a consolidated calendar from many other sheets.
Hi I am currently developing departmental marketing calendars with a team for different portfolio's. For example we have events, B2B, B2C, Digital. Each calendar has past and active/upcoming items. My ultimate goal is to get all the data from the calendars and pull it onto a consolidated calendar for the whole department.…
-
How to create an automated update request for assigned tasks based on job roll
Sorry if this question has already been answered but I am having a hard time clarifying what I am looking for to search. I have a sheet of employees with a helper column (called structure) that is displays their job title as a number using descendants (lower the number the higher their position). If needed this can be…
-
Copy row automation not working
Hi all, I have set up an automation to copy rows that have a specific types: Action, Risk, Issue, Decision. However, the automation also picks up rows with other types (like "Agenda item" as screenshot below) Does anyone have a solution? (Original sheet) (Sheet where the row is copied) (Automation)
-
Automatically disconnect sheets from Resource Management when deleted
Could you develop a fix that makes sheets automatically disconnect from Resource Management when they’re deleted—either initially or when they are permanently deleted after 30-days. It’s quite annoying to hunt down a deleted sheet—because you have to know the owner—and when it’s permanently deleted, you see that there’s no…
-
Has anyone else had VLOOKUPS start randomly throwing errors despite no changes made?
I've noticed since Thursday that on one of my sheets, the VLOOKUP will randomly throw an #INVALID ARGUMENT error despite the formula already working and having no aspect of it change. It seems to randomly do it sometimes when opening the sheet, but I've noticed that it creates an error every time if a new entry is…
-
Merged: Implementation of Data Shuttle-Workflow Folders for Enhanced Grouping
This discussion has been merged.
-
Pasted text from OneNote to Smartsheet cell appears as an image?!
Hi, When you paste text from OneNote into a cell in Smartsheet it appears as an image. This is so annoying. See attachment. The only workaround is to paste the text into a web browser or word document, then copy/paste that back into Smartsheet cell. This is affecting our use case somewhat, as often in project meetings our…
-
Highlight "e" in duration column
Hi, I'm trying to highlight all tasks with an "e" in the duration column, since "e" overrides all weekends and holidays I need to be mindful as to not forget an "e" somewhere when the schedule changes. The Conditional Formatting does not work to highlight it by just saying "if duration contains 'e' then apply this…
-
Cascading timelines by linking timelines
I have three grid sheets, named Sheet 1, Sheet 2 and Sheet 3. The timeline of Sheet 2 is dependent on Sheet 1 timeline and the timeline of Sheet 3 is dependent on Sheet 2. I want a function wherein if the end date of any one task of Sheet 1 gets changed then it automatically changes the start date of the task of Sheet 2 or…
-
Help setting up a daily tracker
Hello! My team is attempting to create a sheet and form that counts the amount of inventory of a product we are overselling per day. We essentially would have the inventory start with 15 units per day, we are going to request the number they sold for each entry. The goal is to have the number they enter in the form will be…
