Hi all, I am trying to use the count of a symbol across some sheets. I know I can get this information by creating a report but for a more visual presentation, I am looking to get an actual number. I …
I am attempting to have a RED Flag populate in the "Risk" Column for cells where the "Available Space" is less than 10. Kindly when answering, please complete the entire formula from start to end as f…
Below are two screenshots. The first is a screenshot of my target sheet. The other is a screenshot of my reference sheet. On the reference sheet I have a list along the left. In the column to the righ…
I’ve created a modified version of the AIA G703 form in Smartsheet for use in monthly tracking of my financing of a land development project. Each time a new funding request is made, a new sheet is su…
I'm trying to have an automatic countdown but I keep running into an invalid data type or unparsable error. I am trying to show how many days remain until a point in the future (07/17/2018). Here are …
I am aware that limiting characters in a form (text) field does not exist. Is it possible to apply a conditional formatting rule to a text field in a form that alerts the submitter that they have reac…
We are a Habitat for Humanity affiliate. We do a group of different tasks on each day we build. Can I have a task for the days such as Day One, Day Two, Day Three and so on and make that the predecess…
Hello friends- I am creating a spreadsheet to help track project financials for a specific grant that the non-profit which I work for received. Specifically in the Summary Table, I have a sumifs formu…
I am using card view as a materials log and I have a question regarding the 'grouping' of cards. The problem: We have a pallet containing 4 boxes. The pallet is assigned to a lane in the sheet. I have…