-
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.
-
Checkboxes on one sheet to copy specific cells to another sheet
Okay, im new so just learning smarthsheet and ive been through vlookup (that didnt seem to work) and now IF (which did what i wanted at first but then ultimately was disappointing. This is the setup: Here's what im trying to do: I have an overall recommendations sheet that allows a client to pick and choose the subsequent…
-
Color code the cells
Hi All, I have a question regarding color coding the cells on Smartsheet. How can I color code column (Actual Delivery date) to highlight the following: Dark green : for when the Actual date is equale or less than Date committed Light Green : for when the Actual Date is after the date committed Red : for when Actual date…
-
Meeting Room booking using SS Calendar App
Hi All, I'm in the process of setting up a meeting room booking system where I display date/time availability and different status indicators (confirmed, tentative, waitlist). I'm currently using two sheets: one to collect meeting information via a form and the other to manage meeting slots on the calendar. I've…
-
Comparing Data in two Sheets
Hello, I have a large list of 926 individuals who are identified by IDs in one sheet. some of these individuals are no longer active. I am trying to find a simple solution to compare the individuals in one sheet to the 3+ separate Rosters that hold the active individuals in other sheets. Basically, if they are in a the…
