-
Is there a way to format numbers from decimal into fraction like excel does.
I am in construction and the need for fractional formatting is very important. I have seen other community questions from 2017 regarding this but has not been updated. Will there be an option for the formatting soon?
-
Weather icon on calendar view
I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast.
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Change status automatically when selecting % done
Hello I have searched through the Help centre (center!) and I can't find the formula (if one exists....) that will automatically select the appropriate value in the % done when one of 6 choices from Status is chosen. So when I select Not Started, I would like 0% to appear in the % Done, Started=25%, In progress=50%,…
-
Smartsheet - Procore & Cyberco Sync
We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this subject.
-
QR Coding Tied to Forms
Hello, I'm looking to develop a process for maintaining our mechanical equipment. Ideally a Technician could scan a QR code that would link them to a list of form links. (Each piece of equipment requires 3-5 types of maintenance, requiring 3-5 separate forms) When Creating form links, can they be renamed? Thanks
-
Convert text date, to date 2018-04-18
I have a primary field that contains date information and I need to convert it to a date, so that I can compare it against another date field. The format of the text date is 2018-04-18, and I need to convert it to a date, and cannot find a formula to do that. Any help? thanks d
-
Let's get the ball rolling! Say hello and share a new or favorite way you've used Smartsheet.
I'd love to get some initial conversation going in this group. Please say a quick hello to your peers and share either a new use you've found for Smartsheet recently, or your favorite thing you've created in Smartsheet overall. I'll share my favorite dashboard I've seen recently. This one was created by one of my…
-
# of Tasks Assigned to Each Person from a Folder
Hi All, Working on trying to find a solution to the following. We have a dashboard we'd like to use to understand the workload across all of our standard projects. Specifically, we want to know the number of tasks assigned to each person by health status. The Folder "Standard Projects" includes multiple sheets, and will…
-
Does anyone know a way for tracking quantity deduction when it comes to material requests ?
I have been trying to track via the activity log on the right hand of the sheet, however the reports are taking too long to produce. I just need something that i can send to the accounts team that shows how much material was used in a week. Please let me know if anyone has a solution. Thanks, Brendan