-
Alerts & Actions
I am trying to ultimately set up my sheet to automatically send out Update Request 3 days (or whatever I set) within the "Bid Date" loaded into the sheet. It would be ideal if this update request would be emailed to the contact in "Sales Rep" column and copy (cc) me in the emailed Update Request for all of them. I was told…
-
Dashboard
How can I create an A0 landscape dashboard canvas
-
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