-
data synchronisation issues
Context: I have recently started testing Smartsheet, though the organisation I have joined has some established uses. So I am in a familiarisation and test phase. Talking to another user recently, he expressed concern about the Smartsheet user experience and data integrity / synchronisation. He had updated a cell in a…
-
Separate numerical and text values of differing lengths from a single cell into separate columns
How do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a numerical value. The numerical values to the left are of differing lengths, making this problematic. The…
-
Attachments in Forms
Hi Everyone, We have a form which will be filled by the customers. There is a attachment field added to the form. Now, we want two types of attachments to be done - 1. Invoice copy & 2. Images of the issue. Invoice copy should be mandatory, images are optional. Is there a way to do that in forms? We can either make the…
-
Is there a way to allow users to email comments without viewing the smartsheet?
Hi, Is there a way to allow users to email comments without viewing the smartsheet? Is it possible to modify the email that gets sent when you @someone@something.com from the automation@app.smartsheet.com, remove the reply in smartsheet box so they just reply to the email? When you add them as a commenter they can view the…
-
How to create an Index Match Formula for multiple sheets?
Hi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns that it will look at. A "TIDC" column where staff members place a ticket code An "Assigned to" column, which is a contact list…
-
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…
