Hello Smartsheet Development Team, We would like to request enhancements to the Smartsheet Proofing features to better facilitate the processing of RFIs and Submittals in the construction industry. Currently, due to limitations and licensing requirements, we have paused using this solution and reverted to manual data entry…
Hello, We're starting to integrate our construction team into our broader Smartsheet project pipeline for new construction projects. I'm wondering if anyone has had any success or guidance on how to pull budget and forecast data from Procore into Smartsheet. Thanks, Dylan
Hello Friends! I have a form that my field crew uses to check the condition of our machines every morning, which includes the most recent hour/meter reading. There are (5) machines that we own that I want to isolate the most recent reading into a dedicated cell in order to determine how soon the next service will be. Also,…
Hello, Can anyone help me write a formula based on the following conditions. Risk Status = "Green" if the following conditions are met: [Delivery Confirmed] is checked Risk Status = "Gray" if the following conditions are met: [Release Date] is Blank Risk Status = "Red" if any of the following conditions are met below:…
Hello, is anyone working with a real estate/construction project management template dashboard that they have found helpful? We are a project management firm and we are having trouble finding dashboards that meet our needs.
I need help finding a way for my reports to automatically pickup new files. I have numerous reports that need to reference everyfile that is in a given folder. When these are first setup, it is very easy to select the folder for the "where" portion and it grabs every file within those folders. However, it doesn't appear…
Where do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much.
Is there a way to place drop down lists on the dashboard yet? Need direction..
This discussion has been merged.
I want to change the number of stars in a symbol column to a number equivalent in a column next to it, but do not seem to have the formula correct. It looks like it is a valid formula, but all I receive back is a blank. Here's the formula: Any thoughts on how to make this work would be appreciated. Thanks, Bill
