-
See projects rolled up in a program gantt
Apologies in advance if this has been answered before - and I imagine it must have been since it seems a very obvious and primary requirement for managing projects in a business. Still, for something this fundamental I just can't understand why I can't see anything in the solutions centre or a search here in the community.…
-
Identify duplicate dates and exclude blank cells
I am working with a SmartSheet that is used by multiple people to schedule meetings. I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)". Dates are entered in rows 7-28. I have added a checkbox column titled "Duplicate Date" to be checked if a…
-
Populating a Second Sheet
I have a form created for a sheet so that when it is submitted it adds a row to Sheet 1. How do I have a second sheet recognize that a new row has been added to Sheet 1 so that it can pull data from a few of the columns? Thank you, Matt
-
Index or Vlookup or What?
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 wanting to pull data from the Budget cell based on the Job ID and the Cost Category. I'm not sure if it is a Index - Match…
-
Best way to export a Dashboard?
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 dashboard view to PDF or image format and attach it for those that want to view offline (and back up in Dropbox).
-
Bar code scanner not capturing actual bar code only numbers/text
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 will only scan the numbers and/or text. I have tried over ten different bar codes on various items with no luck. Please…
-
Can we export a set of detailed files along with high level report?
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 management team. When sending status to the executive team, also include the detailed information from each sheet in the email…
-
Report Builder and Sheet Summary Report - Auto add new sheets
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. Ideally, a Sheet Summary Report would look through ALL sheets, given my chosen criteria and return the results I'm looking…
-
Nested Crtiteria
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. =COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary…
-
Status for At Risk tasks due in 7 days
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 automatically changes the RYGB balls when the status is changed manually: =IF(Status2 = "On Track", "Green", IF(Status2 =…
