Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am…
Print view looks terrible, especially when we have an embedded Calendar view widget it shows up blank. We have widgets: - Report - Shortcut link to sheet - Calendar view We would like to "back up" the…
I am trying to build an inventory/stock management sheet but i cannot scan the actual bar code image into the sheet. I have tried using an Iphone XR and a Samsung Galaxy S9 with no luck on wither. It …
I would like to create a Smartsheet for 10+ programs. Each PM will update their own sheet on a weekly basis. PM Manager will generate an Executive Report from the data of all 10+ sheets/programs to ma…
I successfully use the Sheet Summary Report - however, when I deploy a new Workspace, I must manually go back to the Report Builder and add the sheets that I want included in the Sheet Summary Report.…
Hi, I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria…
I have 4 status categories for my project with respective RYGB balls: * Complete (blue) * At Risk (red) * Requires Attention (yellow) * On Track (green) My current formula in the Health column automat…
1. I have Action Items that can be reviewed by up to 3 Reviewers (Reviewer 1, Reviewer 2, Reviewer 3) before being Submitted for Approval. Reviewers are identified by Name. Reviews are done in paralle…
Hi all, I have a spreadsheet that has set up an "Update request". Now, that same update request was set up to notify both myself and my colleague (since i was on annual leave recently, so nothing was …
Hello everyone ! I could use some help with some dashboard 101. I've been trying to find a way to roll up data for a while without success. Let me explain the situation: I've created a "project folder…
