-
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…
-
Index & Match Formula to provide row number if found in column
=IF(INDEX(ColumnA:ColumnA,MATCH(ColumnB@row, ColumnB:ColumnB,0), INDEX(Auto:Auto, MATCH(Auto@row,Auto:Auto, 0), ""))) Auto = System column to pull row number ColumnA =Text ColumnB =Text ColumnC= Formula location & Row Number Output So, what I’m trying to achieve is to have a formula to Lookup ColumnA text and match ColumnB…
-
Checkbook "Cleared" Balance
Hi, new here, so thank you for the opportunity to ask. I've got a simple checkbook set up, with all the typical entries: date, amount, type transaction, etc. I have a "reconciled" column, "CLR," that I'll type in "R" when it clears the bank. What I've been beating my head over for several hours is a formula that updates my…
-
Only Unique Contacts Formula
I want to create a column formula that pulls all the contents of multiple contact cells @row and only print the contacts that are unique. I don't want to print the same contact in there twice if here happens to be duplicates. Additionally, this needs to be a "contacts only" field so we can reference this for alert…
-
#DATE EXPECTED Error
I am trying to create an email reminder automation on one of our project schedules. We want the alert to go out 10 days before the line is set to be due (Finish Date Column). I created a date column to generate the reminder date (for the automation to use) by subtracting 10d from the finish date column. Some lines in this…