-
Smartsheet Teams Integration
Hello, Is there a way to set up a Smartsheet workflow to directly message the target person on Microsoft Teams? Thank you, Luke
-
Index Match Across Multiple Sheets
Hi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX({Status},MATCH([Proj ID]@Row,{Proj ID},0)). Each sheet is for a different team,…
-
Rows Reordered
Our sheet is used as a chronological order of events. Often when others are working in the same sheet, everything gets set out of order. I know Smartsheets does not support autosorting outside of reports. However, it would help if I understood how this jumble begins! When the sheet is set out of order there is no…
-
NESTED DISTINCT COUNTIF FORMULA?
I have another complex situation Now that I figured out how to "batch" items. The next thing I need to do is pull in a list of "Tote Numbers" that are associated with that batch. In this case I DO want the list to be within cell, but I also want it to be based on the batch number. here is a flow chart of the system - many…
-
I need to string together many conditions
I have 8 conditions I need to string together, if all are met the formula should return "yes" if anything any condition is false, the formula should return "". I have tried nesting If/ and statements a number of ways, but since they all need to work together I am coming up #unparsable with each iteration. =IF(AND([Contract…
-
Calendar functionality
Is there a way to make a recurring event for weekly or monthly easily? I know that I can copy and past into the grid and change the dates but I'd rather use a recurring function. For example, a Saturday market that occurs every Saturday until October. I'd like to add the first date (may 14th) and then set it recurring…
-
Count Cells that begin with a specific text
I wanted to COUNTIF the number of cells that start with specific four letters in a column of a reference sheet. I used the formula below and it returns zero. =COUNTIF({Reference Sheet}, "ABCD") Is there a formula to return the number of cells that have the first four letters as "ABCD"?
-
Combining Formulas to make one big Formula
I currently have all the individuals formulas i'm looking for however I'm having trouble combining them into one formula that I can embed in a cell. I know I can create a workflow automation to get the result I want however I enjoy the rapidness of using an embedded formula. Does anyone know if it's possible to combine the…
-
How can use a field several times within a form?
Hi. I need to collect feedback about several programs using a form. The form should include the same questions for each program. Any ideas about workarounds that allow me to use a field several times within a form? I want users to receive one form to collect their feedback about the different programs.
-
How can I display the most recent entry from a grid sheet in a dashboard widget?
I have a grid sheet which captures status date and status narrative text as columns. For each new status date, a new row is added to the grid sheet. How can I display the most recent status narrative text in a dashboard widget?
