-
LookUp and Match a value located in a cell with multiple values and return single and/or multiple va
Hi, I am hoping someone can help with this formula. I was able to get this working using VLOOKUP when there were fewer complexities. In Sheet 2 when there is a value in the "Lot Number" cell, * The formula should look at Sheet 1 to see if the "Lot Number" matches and exists in any of the cells located under the Lot Number…
-
Complex nested IF, AND with traffic light symbols
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…
-
Generate Cover Sheet Summary Page off of Data?
We have a spreadsheet listing all of our jobs and I was wondering if anyone knows if we can highlight one of the jobs by selecting it and generating a cover page summary report of just that one job? Any advice would be greatly appreciated! Thanks, Crystal
-
Ability to create folders in the attachments tab
Is there a way to create a folder in an attachments tab? We have versions of image files we want to see but would like to be able to create a folder for 'old photos' or something like that within the attachments tab to help sort/seg the attachments.
-
How to determine if a milestone is an extended milestone?
The formula value of [Duration]@row is a numeric value of 0 for both a Duration cell value of 0 and ~0. This means it is not possible to determine the number of work days that Smartsheet will then use for scheduling and % Complete calculations. Does anyone know if there is a way to determine which Duration cell value has…
-
Kickstarter Campaign
I'm interested in running a Kickstarter campaign and haven't done one before... has anyone on here ever ran a campaign for a tangible product development project and tracked it in Smartsheet? Would you be willing to share some insight and maybe some tips on setting it up?
-
ADD LAST COMPLETE DATE
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last column that changed to "complete" status. I really appreciate any help! Rob
-
Nesting ISBLANK within IF(AND) Statements
Hello, I have successfully established a formula link between two date columns (Start & Finish) and my 3 status trackers (Completed, In Progress, Not Started). The formula I have used successfully is: =IF(AND(Start@row > TODAY(), Finish@row > TODAY()), "Not Started", IF(AND(Start@row < TODAY(), Finish@row > TODAY()), "In…
-
Grouped Update Requests
I am looking for a way to send multiple update requests in a single email. Here is the scenario. Once a product is inspected, I want to check a Smartsheet checkbox saying that it passed inspection. Then I want Smartsheet to automatically send out an update request to our shipping department telling them to go ahead and…
-
Risk Status- Grey, Red, Yellow, Green Bubble Formula
I'm not sure why my formula isn't working. I also wonder if I can do Today(-7) in the formula. I've seen +days but not -days so maybe that's the issue? If so, how do I write it such that if the finish date is within the next 7 days, the bubble will be yellow? Here's the formula: =IF(status@row = "Not Started",…
