-
Stop Predecessors from being deleted when a date is deleted
Sometimes we need to just delete the dates to start fresh or copy rows to use for another project, but deleting the dates also deletes the predecessors. I was trying to test a schedule template with many hours of work on defining the predecessors. When I wanted to blank out the dates again so it could be used as a blank…
-
Links in dashboard freezing
Over the last week or 2, I'm finding that dashboard links 'freeze', ie. stop working after some time, ie. maybe 20 minutes or so after dashboard opened. This is happening with dashboards via the desktop app, and with Chrome and Edge browsers. Once it's 'frozen', as I move the cursor around the page, the links are 'dead',…
-
Cell Changed Color When Formula Updated
I just updated a date cell formula to give someone a little longer to complete a list of tasks and they all turned yellow. It' not a cell filled color because you can't remove it. I have updated this formula before and not had any issues with the box changing colors, so I can't figure out why it's doing it now. It's a…
-
Question on graphing data on a dashboard while using a smartsheet form
Hello, I am trying to graph data for production as close to real time as possible. We run a test and then use a form to populate a smartsheet. I have a dashboard pulling from that smartsheet to graph the data. I want the graph to populate based on new data entries, however the graph will only populate based on the data I…
-
INDEX & MATCH function showing "#INCORRECT ARGUMENT SET"
When trying to run this it shows "#INCORRECT ARGUMENT SET" error, not sure where i went wrong. =IFERROR(INDEX({East - Service Status}, MATCH([Ticket No]@row, {East - Service Range 1}, 0)), IFERROR(INDEX({South - Service Status}, MATCH([Ticket No]@row, {South - Service Range 1}, 0)), IFERROR(INDEX({Tamil Nadu - Status},…
-
Collecting time range in form
I'm creating a form to collect the days and times that employees will be out of the office so that I can get the info onto a dashboard for the team to refer back to. Since Smartsheet doesn't have time fields for forms the best workaround I could find was using dropdown fields with half hour time segments and have one field…
-
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…