-
Data entered on a Report doesn't trigger VLOOKUP based on the underlying Sheet cell contents, Why?
I have a VLOOKUP set up to pull a date from a cell on Sheet 1 to a cell on Sheet 2. The date will only populate on Sheet 2 if it is entered directly on Sheet 1. Filling in the same cell of a Report based on Sheet 1 does not populate the date to Sheet 2. I have instructed users to interact with the Report for ease of use…
-
Why is my Level Code formula erroring on just level 2?
I'm trying to produce a WBS. I used the helper columns and formulas from the Smartsheet template set. The Level Code formula works on all but the 2nd level (purple) which shows #NO MATCH. Expectation: First purple line should read 1 and second purple line should read 2. WBS works fine if I hardcode those values. Anyone…
-
Formula that looks at multiple sheets
I need assistance with creating a calculation. I have a list of people on one sheet that has their names and rate of pay. The person fills in a form and enters their hours (form is the Contractor Pay Summary sheet). I need the one sheet to look at the other and pull in the rate of pay for each user. Contractor Sheet This…
-
How to Get Attachment to Work on Automation
Hello All! I have an automation that is set as Trigger: When a Date is Reached —> Run Once on Date at 5pm. Conditions: Where two separate checkboxes are checked. Alert someone—> Message, Link to sheet and specific fields (an attachment). The automation worked except the attachment. It wasn't included at all on the…
-
JOIN/COLLECT -- #NO MATCH
I have used JOIN/COLLECT in many different instances with no issue, however a colleague of mine told me their formula broke (seemingly randomly) and I can't pinpoint why they're getting #NO MATCH [Depature Group] =JOIN(COLLECT([Join Contact Info]:[Join Contact Info], [Group Key]:[Group Key], [Group Key]@row), CHAR(10)) I…
-
Can I do a stacked bar chart of status types by week?
I've been asked to create a bar chart for a hypercare log like the one shown in the attached screenshot. The ask is to have a stacked bar for each week showing how many cases were active in a given week and how many were of each status (New / In Progress / Resolved / Escalated). The ultimate goal is to see the trend of how…
-
INDEX, MATCH, and OR Function
Hello, I am trying to use INDEX MATCH and the OR function. I'm referencing 3 other sheets try to say if we find x in any of these 3 sheets I want y from those sheets. x and y will only be present in 1 of the 3 other sheets. However every I do this I either get an error code or unparsable. These are a few of the formulas…
-
Logic Help
I am trying to come up with a formula that will change my "Has been billed" column to Yes or No based on the dropdown choices in one column and the created date, I am having trouble coming up with some logic that can work around the year with sporatic billing periods. Here is my current formula: I either have remnants from…
-
SUMIFS pulling data from another sheet and applying criteria of a date range
Hello, I have scanned through previous posts and could not find one that matches my situation. I created a Metric Sheet which I want to pull footages from another sheet that fall within a date range. I followed the formula syntax and ensured my headers are correct and the format for date range is also correct but I keep…
-
Copy/Paste retaining formulas with multiple sheet & summary field references
This just may not be possible, but no worse off if I ask. We have a 'table' of data constructed of cells with formulas using sheet references, and summary field references. We are trying to consolidate our metrics into one central sheet for easy annual/quarterly updates as they are used across multiple dashboards. The…