-
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
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Bring in data from multiple sheets
Hi, I'm fairly new to Smartsheet so apologies if this is obvious. I am essentially trying to bring information from 2 sheets which I can then edit or work on. Some background.. We have a sheet which details resourcing for ongoing projects (backlog) and another which contains information on the pipeline. The backlog gives…
