sophiaashepard
sophiaashepard
Discussions
- Hello, I recently received advice on here to develop a formula that lists out all projects that individuals are billing to via cross sheet formulas. The below formula would go into the Projects column…
- Hey! I am wanting to count the number of projects in each department (e.g., Health Action) that are marked as active. I am currently using this formula where I manually enter how many inactive project…
- Hi all, We are using Smartsheet to forecast staff LOEs across projects. We currently have a Data Input sheet where staff LOEs are entered by project (nested by Center). We then have another sheet, Ent…
- Hello, We have a data input sheet where we would like to signify who are key personnel using a checkbox (star). In the data input sheet, we have staff names (Person) as well. We also have a rollup she…
- Hello, I am trying to implement an update process for our Staff Forecast Tracking Data Input sheet. For each project (grey rows), I would like to assign someone to update all the project staff's LOEs …
- Hello, I am trying to find the average risk score across multiple sheets given the criteria of being a risk and being open. I am trying to use an (AVG(COLLECT( but I am getting an invalid operation. H…
- Hello, I am trying to figure out a way to copy a contact from one column over to another column (both columns are Contact List) in the same sheet whenever someone selects "Yes" for a seperate column a…
- Hey, I am trying to add a reminder or notification to people (identified in the row) if they have not updated anything in the row in the last month. Is there a way to do this? If not, I would also be …
- Hello, I am trying to utilize a Risk & Opportunity Matrix to assign priority levels to risks and opportunities. I am using this formula to try to do this but I keep getting an #INCORRECT ARGUMENT. Doe…
