I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel. I have 200+ sites that each h…
To give a little bit of context, I am creating a report where I can count whether a cell has been filled with information. The column I am using is a drop down list with 5 values. Let's say these valu…
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large P…
I am trying to use the RYG balls when noting when a variance has gone over certain amounts: 5000 or less - Green 5000-10000 - Yellow over 10000 - Red I can add grey as my false statement if the coordi…
I have developed a project schedule that is detailed and has information that should not be shared with the client. In order to provide the client with a summary view, I am using a checkbox column to …
Hi, There seems to issues with date formats at the moment. I've had a few client's reach out with issues and I've also seen issues from others in the community. If you're experiencing issues and If yo…
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down. I have a separate sheet that lists the appropriate contact for each ite…
Hello, I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person. =COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Conta…
I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked. Can someone …
I faced this issue when three and more files are attached to the row. In this case, their numbering becomes incorrect. For example, the latest version of the file can be marked as V2 or V3 whereas it …
