-
Visual budget management
Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…
-
Linking from a sheet that's reached the 5000 row limit
Hello Folks, I’m relatively new to smartsheets (3 months) but I’m diving right in creating sheets for a medium size construction firm. My recent project is a daily time reporting sheet for approximately 100 field employees. My sheet is up and running and is being rolled out to a limited number of supervisors during the…
-
DataMesh not finding cell links
I am having issues with DataMesh, as it is unable to look up the values between the sheets. I checked some of them manually, and the numbers exist on the target sheet. I also tried to export into Excel and test this formula. Excel required a re-format of the numbers (text to number format) before it was able to…
-
Has anyone used Tempus by Prosymmetry?
My Smartsheet contact had recommended Prosymmetry to me for my companies resourcing and time tracking needs, and I'm doing due diligence and vetting. Can't find much information on this company including their seed funding or VC info. Has anyone else used this tool? What has your experience been?
-
Number of rows in a sight.
I have a sheet with just under 500 rows, with information about buildings. I have a report to format a concise list of information to publish, and have several widgets, including links to the maps that have some of the source data, on my sight. The Sight only displays the first 150 buildings, with a pop-up link to the…
-
Need a way to calculate hours and minutes
We are using the hours and minutes duration option for our projects and need a way to calculate the stop time based on the duration. We enter the duration and Start Time and want Smartsheet to calculate the stop time (currently we have to enter it manually and there is definitely margin for error... not to mention time…
-
Project Management - IF(OR(AND())) - Formula Help
I've been working on this for some time and just can't seem to get it to work the way I need it to. I am attempting to build one sheet that will allow me to track the status of all the projects in my section, while also tracking the progress of tasks within each project, for both current and historical projects. I have…
-
Best practices and Governance
Hello We are using smartsheet more and more in the organization. Happily :) But as the number of users grows, so does the number of sheets, etc. A sound governance document is needed. I'm now digging into the subject and I'm wandering whether someone went through this exercise before me and would be ready to share its…
-
Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula
I need to add another scenario to one of y formulas, If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose…
-
How do I autofill a formula to new rows that will be added via a web form?
Hi, I'm trying to have a formula autofill as new rows are entered into a project list sheet. I know smartsheet has an autofill formula feature, but I'm not sure how to use it. Is it an automatic thing by default, because if that's so, my formulas from the rows above are not autofilling in new rows created. Any help…