-
How to get a notification when only certain users have modified a sheet
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 at the 'modified by' column, hoping I could hand-pick the users based on this but I can only run this workflow when this…
-
Task duration as a function of the task Allocated %
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. Another case may also be useful. If one person is allocated 100% for three weeks then allocating 300% the task should take one…
-
Sequential Number
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 application as the criteria's differ for each program. Follow is what the formula looks like in excel:…
-
Filter by color
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 a "trick".
-
Filter tables based on dropdown menu selection
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 menu. Some pictures are below to illustrate what I'm looking for. Here's what the raw tables look like. They are laid out like…
-
Error when opening a sheet
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. When we use the search feature it doesn’t appear. When we go to the folder it’s there, but we get the error message when…
-
My average formula is disappearing....
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()) / COUNT(CHILDREN()) The average will calculate correct initially but then Smartsheet Automation deletes the formula and…
-
Change cell color based on date from another sheet
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 color. So, for example, if project 1 timeline had a date associated with 9/12/21 then the cell joining those two would…
-
Row height issue
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 changed the text positioning but the formatting didn't follow. I have un-hid and checked every cell for a spot that may have…
-
How to List Parents By Common Child
I am working on a project book of work and currently have a list of resources listed by project: Project 1: Rich John Angela Carly Ted Project 2: Tim Jeff Rich Ted Project 3: Sam Tim Ted I am looking to create another sheet that will automatically pull from this first sheet and show the resource and the projects that they…