-
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…
-
Issue with ABS function within if statement
I've got a very specific problem with an ABS function nested in an IF function. My formula is basically: IF(ABS(X-Y) <= 0.1,"","Out"). As far as I can tell the formula functions correctly, EXCEPT when X and Y are both values from 7.30 to 7.49. In this instance, if ABS(X-Y)=0.1, then it returns "Out". Ex. when X=7.44 and…
-
Find the value just before Max?
I am trying to use Smartsheet to keep inventory of products I use incrementally but I am running into a formula issue that I am unable to solve. I have been using MAX(COLLECT()) to pull the most recent inventory check for an item, but I want to be able to pull the previous check as well so that I can compare how much…
