-
When cell is updated to new value it updates past and present cell values in target sheet
We have a sheet similar to a price sheet that populates a target sheet via index/match formula. Stakeholders submit orders via a SmartSheet form. However, I don't know how to update orders in the future not in the past. Past order should still be the same value / cost. Thank you in advance for your help. Cathy
-
Formulas not updating when new data is added to underlying sheet
When new data is added or updated to the underlying sheet, the formulas are not recalculating. I run an upload workflow each morning and want the metrics sheet below to recalculate based on the updated report I attach. I have to manually re-enter the formula to get an updated metric. The counts, averages and formulas using…
-
How do I calculate the average time a representative takes to resolve a call per month?
I have created a weekly intake form that managers complete documenting how many calls their employee handled as well as the average length they were on the calls. I am creating a roll-up report where I need to calculate the monthly average length of time it took each employee to handle the call. This screenshot show how…
-
Vacation Tracker - half day entry requirement
Hi everyone, I found a great youtube video that helped me build a vacation tracker for my business. Only problem is the tracker covers only full day vacation requests. Could any of our great experts help me to amend the below formula to incorporate a half day vacation request? I guess I would need to add a column into the…
-
Task Health: formula dependents on Creation Date
Hello there, I need to automate the Task Health column basing on the following criteria: Blue: creation date is in the last 3 months Green: creation date is between the last 3 and 6 months Yellow: creation date is between the last 6 and 9 months Red: creation date is more than 9 months old Thanks for your help
-
AI Access
Hi, The latest update on innovations mentioned that the first AI feature, AI formulas and generative content, is available now to EAP members. I can't find any information about how to use this, is there any more information on how to get started as an EAP member? Thanks, Madeline
-
MIN and COLLECT formula not working
Hi all, I am trying to return the oldest date from a date column where a checkbox is checked in another. The formula I currently have is below =MIN(COLLECT({Change Requests Range 3}, {Change Requests Range 5}, 1)) The error I get returned is "#INVALID COLUMN VALUE". I have screenshots below of the range details as they are…
-
A function to validate Standard / Universal Naming Conventions
Hi It would be really helpful if we introduced a function capable of validating complex patterns of characters, numbers, and symbols in the given cell --in a predefined manner! Let's assume, the supplier-IDs in a business follow a universal/standard naming convention such as "SUPP001DEL2324 H", "SUPP002DEL2324-M",…
-
Formula involving Today() is returning the wrong number
I have a formula in my project plan summaries to keep track of how many days are remaining in a project. The formula is (=Finish3 - TODAY()). This formula works in other sheets. I have one sheet where it is not functioning properly. Finish3 is a date cell that is a rollup of the finish dates of all tasks in the project. It…
-
Merged: Lookup prior issuance on Smartsheet and display results on form
This discussion has been merged.