I am looking for a way to set up an automation for deleting rows in a sheet. My firm is unwilling to go through security testing right now and is wary of putting sensitive data on Smartsheet, but is w…
Hi, I'd like to setup a workflow to get an alert but only when certain people have made a change to a sheet (around 75% of the users who have access to the sheet). I tried to setup a workflow to look …
Hello!, Can task duration be calculated as a function of the allocation percentage? If one person is allocated 100% for one week then being allocated at 50% the task should take two weeks, etc. Anothe…
I am creating a Project Numbering system in a sheet that are generated based on selected criteria's. The last 3 digits would need to be sequential numbers "000" Auto-numbering will not work for this a…
Is it possible to filter a column by color? We use visual management extensively for some of our larger enterprise projects and filtering by color is helpful. I didn't see a way, not sure if there was…
Hi all. I've been tasked with mapping some data key connections between a large number of tables. I am looking for a way to display only the tables that match criteria from a single-select dropdown me…
As I finished working on a sheet last night I got an error message saying to log off and back on. I logged off for the night and now we’re getting the same error message when trying to open the sheet.…
Hi SS World...very basic user here trying to determine the average of children rows in the parent row. Tried using 2 different formula's in the parent row (white row): =AVG(CHILDREN()) =SUM(CHILDREN()…
Hello! I'm working on a project overview sheet for many overlapping timelines. I'd like to make it so that if any of the projects have the date that the column is named that cell highlights or changes…
I know that row height can not be manually adjusted like in excel, that's usually no problem. In my case, one sheet has had some select rows height change, as if someone wrapped/unwrapped text or chan…