-
Using sumifs to tally up certain date ranges
Hi All. I'm working to understand the more complex formulas of smartsheet but have been stumped. I'm looking to sum the work area total amount of a task based on the start and finish dates on the Gantt chart. I want to see what we will bill per month. The Gantt has each work area with dates and work area pricing totals. I…
-
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…