Hi everyone , I am attempting to create a scoring system for a survey based on this type of scoring below. These are the survey questions and it already built in a sheet. Thanks in advance for the support.
I have a summary page that pulls in key dates from other sheets. I set up automated workflows based on those date fields, and found that they don't run (I assume they don't recognize the data in the date fields). This feature would be extremely useful for me. Is it something that would be considered?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
Hello, I have created a PTO tracker to log my project team's PTO during the project lifecycle. The PTO tracker that I created is a separate sheet from my project schedule. Is there a way that I can create some conditional formatting (maybe via a checkbox helper column) to link these two sheets and indicate where there is…
Hello, I am fairly new to SmartSheets - I am trying to figure out how to pull data from one sheet to another that would have a names in common. I.E. Sheet 1 has a course name of Smith AR Training. Sheet 2 has the Region Name as Smith in one column and then a contact person in the 2nd column. Because Smith is listed in both…
I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
I want to create a grid sheet that is similar to this: I know merging cells is not possible in Smartsheet, but is there any other way to achieve this? thank you so much !
I have a sheet with outbound cell links to several other sheets. I've deleted some of those sheets, so now I see outbound links titled: <unknown sheet> When I open the Sheet Reference Manager it does not show any cell links. In the cell linking help articles I did not find any statement that the Sheet Reference Manager…
Hi everyone, I have a project plan with several rows. There's a STATUS column in which traffic lights colours (gray, green, yellow and red) appear depending on the closeness of the task to its deadline. In another sheet, I'd like to link a cell to the STATUS column and use a formula that counts how many red dots there are…
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…