-
Cross-Sheet Project Status Rollup (Dashboard?)
Long time user, first time trying to do something cross-sheet. Lets say I have a folder called "Projects" and it contains all "Project Sheet" type sheets. Outside of the folder I'd like to have a sheet or a dashboard that dynamically looks at the sheets inside the folder, list out the sheet names with total % complete. Any…
-
Jira Smartsheet Workflows are not static
Not sure if I am expressing this correctly. However, my workflow I set up on Friday worked perfectly, but I noticed it was not updating when changes were made in Jira. When I go to edit to looked back at the workflow the Settings say under Jira project: Configure Jira Instance . However, it does show the proper Jira…
-
If statement to auto link to different cells
On our PM sheet we have stage summaries which show the % complete, start/end date, and a RYG dot. All of this information appears on a dashboard. Currently when we change stages we have to re-link all of the above info to the dashboard but is there a way we can have a formula that automatically links to the corresponding…
-
Cell linking
I have two sheets with several common columns. One of which is closing dates. I want sheet B closing date column to look at sheet A and pull the closing date for each row. The sheets have common columns for lot# which would be the field to index on. In other words, if lot# 1 is closing on 4-1-18 this gets entered into…
-
Pull from another worksheet IF criteria is met
I think I need an IF formula, but what I'm trying to do isn't working so far - so I reach out to the community! I want to pull information from sheet A (client name, phone number, e-mails, what they purchased, etc) which is the master list of all the clients and what they purchase, to sheet B (to schedule work, this is a…
-
Adding back in deleted rows
Hi, How would you recommend I add back in the action indicator row if it was previously removed by another user TIA
-
Sheet Data Reports
Hello SmartSheet community! We've been using Smartsheet for a while now throughout our company and so far have several sheets. Some have important deadlines/dates while some just have to-do lists with several tasks that are flagged as important. I'm having difficulty figuring out how to compile all of the upcoming dates,…
-
#DIVIDE BY ZERO - Return Blank Value
Hello, I have read about the IF formula, but am having difficulty applying to cells in question. I am still trying to have #DIVIDE BY ZERO return a null value when other fields are not yet populated. Any support would be greatly appreciated! Screenshot: https://ibb.co/g8PBn7 The idea is that when # of Products is blank…
-
More than one contact in the contact list drop-down
We have a column type "contact list" that we use to track sales reps for individual products. Sometimes we have a product with more than one sales rep. I created a group with both sales reps as part of the group thinking I could use the group as the contact. It isn't available in the dropdown, only individuals. I want to…
-
Facilities Maintenance Plan
Hi, Does anyone use SS for their facilities maintenance planning and tracking? If so, I would be interested in touching base. We are putting together a multi-year facilities maintenance program in SS and any help would be appreciated. Thank you, Archie Lopez
