Formulas
Discussion List
- 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 …
- 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 t…
- I need to add leading zeros to month numbers Jan-Sept only as sorting by month number does not work due to Months Oct-Dec starting with number 1. If I sort by month number, it comes up like this. 1 (J…
- Hello, I have created a report that shows the manager's name with the count of missing ratings. I would like to pull out this information and put it into a metric sheet that would have the manager nam…
- Hi, I have a order intake sheet where I refer the stock quantity from Item master sheet and grant amount from Grant master sheet. I'm doing most of the calculations(like quantity check and cost check)…
- I have a formula that works with one Criteria range however it is not working. The Formula that I am using is. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]…
- I have a cell that is for quantity of material used. Say I put in 3000. Tomorrow I want to put 2000, instead of manually adding it together to get 5000, how can I make that cell auto-add to get 5000 a…