-
Index Match with 3 criteria
I want to use the indexMatch formula to get data in the [Column 1], the columns that have to match in the other sheet ([Sheet 2]) are [Project Number], [# Division] and [# Bundle]. I have been trying using the AI formula generator and it gave me this formula: =INDEX({Range Sheet2}, MATCH([Project Number]@row & [#…
-
Join+Collect by rows
Hello, I am trying to create a smartsheet formula to aggregate summery information from an amendment sheet onto a master sheet. However, when I attempted to use join() +collect() my cell returned all date finalized collected then all #s collected and then all types collected. I want to return data in ROWS not COLUMNS. In…
-
Use if(contains) based off of items that are submitted today
I want to used if contains to only search on rows submitted today. This formula doesn't work. (Invalid Operation) =IF({Daily Swing Stage Submission Range 1} = TODAY(), IF(CONTAINS([Swing Stage ID]@row, {Swing Stage Submitted}) = "TRUE", "Submitted", "Not Submitted")) But this formula does, but looks at all entries in the…
-
Smartsheet Generated Document Updates
Good Morning. I have a Smartsheet generated document. If a field that is mapped to the document is changed, the document is not updated. Is there a way to make that happen?
-
Summary Fields for Dashboard based on dropdown values
Hi All, I have a rewuirement and, although I have a solution, it is very manual. I was wondering if there was a better andmore efficient way of doing what I needed. It is a question of reverse engineering in that my requirement starts with the end product a dashboard. On this dashboard I wish to show, in graph format, how…
-
Date Formula Question
I have a date request for each month by week assigned to their DCO’s hierarchy. 1st week of the month Brenda Van Roosenbeek, Daniel Farmer, Carolyn Monroe 2nd week of month Courtney Batey Coates, Sara Speith, and Lisa Funston 3rd week Julie Starry, Kerry O’Leary, and Becky Harper 4th week Alison Swetter, Scott Withers, new…
-
Timeline Calculation
Hello everyone, I am trying to write a function that gives below output: If date reviewed on or before the due date or within one week after the due date, the outcome should be "On-time" else "Not On-time" If date reviewed is blank and the due date has already passed the output should be No. of Days Overdue If date…
-
Formula to lookup a value based on start and end date
Hi All, I need your support on this case. I have a project to improve the current sales report layout and I need to extract the Vendor Support data for each item depend on the sales records, and the start and end date for this vendor support. Here is an example: Below is the table where I want to have the formula to…
-
How to adjust formula for stacked bar chart to use HAS or CONTAINS
I have a stacked bar chart that displays how many initiatives are assigned to an individual by year. (See example below.) We've recently changed the source sheet from only allowing one year per initiative to allowing for multiple years (for initiatives that span multiple years). How do I adjust this formula to count if…
-
Range and how to designate it
I have customised the Employee Pulse Check template, I have added a question to Survey Intake that is not in the template, Survey Intake converts the answer to the question into a number, so I have applied the same function to the newly added question. The same function was applied to the newly added questions. How can I…