-
Is there a way to maintain currency formatting when within a formula?
Hello all, I want to use document generator to make annual compensation letters. Leadership wants the compensation dollar amounts to be formatted within paragraphs, which makes a traditional fillable form a little challenging when I need to be super precise about being in line with the rest of the paragraph. They want one…
-
Automatically Capture Completion Date When Status Changes to Complete
This discussion was created from comments split from: I have a start date, due date, actual date completed. I need to track the number of day from start k.
-
Smartsheet not recognizing my Date Check formula
I'm trying to use a date check formula from a cell that is linked to another sheet to check the date that is populated by the linked cell to determine data that is presented in another cell. Here is the formula: =IF([Date Received]@row < DATE(2023 / 7 / 1), [Total Grandfathered Rent]@row , [Total Standard Rent]@row ) Let…
-
Can I please get some guidance on making this INDEX/COLLECT formula work?
I am pretty familiar with using INDEX/COLLECT but I am trying to use it in a context I have never tried before. This is where I am so far… =IFERROR(INDEX(COLLECT({COQ Source List Range 3}, {COQ Source List Range 1}, =[Appraisal Item]@row ), 1), "") I believe I need to use the OR function somehow to continue. I actually…
-
Date match formula
Cross reference sheet formula, I am trying to return the value of a cell when the date matches my current month formula. I am sure this does not make sense, see screenshot.
-
Finding duplicates
Finding duplicates so that I can use conditional formatting to highlight the duplicates. Why am I not getting the 2 in the "find duplicate" column? I also tried =if(countif([ref. no.]:[ref. no.],[ref. no.]@row) >1,1). what am I doing wrong? Thank you in advance,
-
How to automatically add NA to a date column in 1 case, which is updated manually in other cases?
Hi, So, I have a date column, say Date A. I have another column say 'Condition A'. When 'Condition A' column consists of a value 'ABC', then Date A column should auto populate with 'NA'. In other conditions when Condition A column has 'XYZ' or @'PQR', Date A column needs to be filled manually by the smartsheet user. Now,…
-
Distributing Savings Across Months Based on Term Date and Fiscal Year
Hello My Super Intelligent Smartsheet Community! I have attempted to solve my problem by breaking it up into pieces and I'm stuck. I think I've been trying to solve this for too long and my creative juices are fried. I have Service Providers we have contracts with. Each contract has a Contract Start and End Date and our…
-
Cross reference sheet average number of days between two columns/dates while excluding blank values
Hello, So to be able to do this so far I have added a helper column to my main smartsheet. This column I called "Days Between" just counts the amount of days between column Referral Faxed Date and Eval Date. Helper column code: =([EVAL DATE]@row - [REFERRAL FAXED DATE]@row ) This seems to be working fine but we don't…
-
Lookup on a Many to one sheet
Okay, this may be a bit tricky, so I would appreciate your help. I will be creating a new sheet, and accessing both of the sheets below. Let's call the screenshot at the top, SheetA, and the one at the bottom SheetB. Now, SheetA is a "one to one" with the TDLs listed in the column on the right, there is only one entry on…