-
RYG Formula Average
Is there a way to take the average of the RYG colors and roll it up to an overall summary for a section and then the overall section to the overall project summary? I've included a snapshot of what I'm talking about.
-
Stop Modified date updating for formula cell/column
Hi, I have a formula in place to have a certain value in a cell if the modified date is today "Updated", and if not display a different value "Not Updated". However, this seems to work when I open my sheet the next day the value is "Not Updated", but then the modified date updates after saving, because the formula has…
-
Auto-populate a cell based on column dropdown
Hello, and many thanks in advance for your help. I'm new to Smartsheet and spent some time looking through the various answers on this community forum and could not figure out the answer to this question. I've attached a screenshot of a smartsheet I've made. I added a section at the bottom of my sheet called Reference. My…
-
Dependency from a cell on another sheet
Hello, I run my manufacturing jobs on Smartsheet. I have one sheet with multiple projects on it, Parent row per project and tasks indented I have a few milestone dates in each project for equipment arriving (this date is linked from a shipment tracker) which other task tasks within the project are dependent on before the…
-
Storing documents in a folder, in a Workspace
Looking for best way to share and store documents (Word, Excel, Visio, PDF, etc) inside of a workspace. .. Ultimately, would like to have a tree of folders that will serve as a Data Room for a particular project. Has anyone tackled this previously? Any way to make it work effectively without having to attach to rows and…
-
Formula
I'm looking for a formula that would let me update the status column when the %Complete has a value entered. It should read if 0% is entered Status would be not started; if a value of 1-99% is entered then it is in "Progress" in the status column. If the % Complete value is 100% then the status column would show "Complete"…
-
MS Flow Integration
I am currently trying to use MS Flow for workflow task automation for various projects. Does any documenation exist on how to access the data within the sheet? It appears that the dynamic data available only presents a limited set of items that are not detailed enough.
-
Calculation from number in a checkbox column
I'm trying to create a column that would allow some groups to report progress as a percentage and some to simply check a box for 100%. I've written my formula, but as soon as I enter a number within the checkbox column I receive the #Invalid Operation error. Any help would be appreciated. =IF(Progress4 = "True", 1 *…
-
Link a summary sheet to multiple workplans
I'd like to be able to link to fields in a separate worksheet based on certain criteria. I'll give an example to try and explain: I have multiple projects running concurrently; each has a separate project plan as they are shared with different stakeholders. Each project plan has an overall RYGB status, based on the 'worst'…
-
Creating a Purchase order spreadsheet
Wondering what template might be the best way to create and share a purchase order system for our construction projects. I want to add links, pictures, pricing quantities etc. Can anyone help with this