-
IF WITH 2 CRITERIA
I'm looking to make a formula that will do the following: search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES" otherwise "NO" I included an image that hopefully clarifies this a little more. in the image I show 3 "A"s in Column2, 2=YES and…
-
Developing a Matrix Questionnaire
Hello, I am hoping someone can help me design this type of Survey Form to send out to my work employees. I would like to ask them to pick an answer (that I give them), by selecting the radio button. It seems easy enough however, I do not see this. I have attached a screenshot. If you know how to do this, I would really…
-
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…