-
Enhancement Request for Smartsheet Proofing Features
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…
-
Procore and Smartsheet Sync for Budgets/Forecasts
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
-
Form Submissions: Multiple Condition IF Formula Isolated to Most Recent Only
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,…
-
How To Have Risk Column Automatically Update Based On Certain Conditions
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:…
-
Real Estate Project Management
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.
-
Auto reference a file added to a folder that a Report is pulling from
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…
-
Zero Formula
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.
-
Drop Down List on Dashboard
Is there a way to place drop down lists on the dashboard yet? Need direction..
-
Merged: Extra Fields For Contact List
This discussion has been merged.
-
How to change star symbol to number equivalent?
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
