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: …
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…
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 …
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 i…
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…
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 recen…
=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= Formu…
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 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 …
