-
Match Function to Return Required Digits
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…
-
INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
-
mailto: Function in Sheet Cells
Imagine the following situation: you’re working within a worksheet and want to add a hyperlink to a cell, you can reference a URL or another Smartsheet file. But I’d like to reference to an e-mail address. E.g. we got our suppliers names in this cell, and want to write them as fast as possible a message. And by just…
-
Formula Index Match inconsistencies
Hello, I have been using an Index match formula, however it doesn't always pull back the correct match or provides a no match however when validating the data, it is there. Is there a better formula to use? Here is what my current formula is in the cell: =INDEX(reference sheet column),MATCH(@row in sheet,(reference sheet…
-
Seeking automation for Monthly Dashboard with separate Month Rows
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
-
Pulling from 2 different sheets into one sheet
I am trying to pull project phases from one Smartsheet and project checklist items from another sheet into one sheet. I would like the information from both sheets to be on the same line in the destination sheet. (Report puts them on two lines) Below is my current formula and I received the error #Incorrect Argument Set
-
COUNTIFS Statement with dates and other criteria
Trying to count how many design starts are projected for each month within the Western region. Below is my formula; however, it doesn't seem to be functioning properly. I am referencing another sheet and I've confirmed that the references are pointed at the correct columns. =COUNTIFS({Summary.DesignStart},…
-
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…
-
How to calculate the first date of the previous month, including when the year changes
I had the following formula set up to calculate the first date of the previous month, and now that the year has changed the formula is no longer working as intended to pull in December data. How can I fix this so that it shows the date as 12/1/2025? Current formula: =DATE(YEAR([Date Column]10), MONTH([Date Column]10) - 1)…
-
Index/Match
Hello when matching between two smartsheets using this formula =INDEX({Livestock Transferred on Range 3}, MATCH(nlisid@row , {Livestock Transferred on Range 4})) it sometimes returns #NO MATCH even when there is the same exact data in nlisid to match to, they are both dropdowns. Out of 909 lines 59 are not working…