-
Formula to Link PTO Tracker to Project Schedule
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…
-
Pull data from one sheet to another with same words
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…
-
Can I turn off the "Used in formula on" information screen?
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?
-
alternative to Merging cells in Smartsheet
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 !
-
Managing Outbound Cell Links: Entire Sheet
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…
-
Formula that counts the total of red dot symbols in my status column
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…
-
Basic A/P and A/R payment tracker
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…
-
Array and Index Training Records to pull who needs to complete something within a date range
I manage training records and am creating a dashboard to manage who needs to complete a training. I have a master sheet with the employee name, and a reference column to them completing the training and when it is due I then have a calculation sheet to count how many people fall within that date range =COUNTIFS({HiPot…
-
Multiple cells locked to single formula in same column
I'm relatively new to Smartsheet and use it as a tertiary tool, so apologies if this is a 'basic' question. What I want is to tweak a formula on one row of a column and have it apply all other rows that reference that cell in the same column so I don't have to copy the tweaked @row + Parent, Children, or Ancestors…
-
Cell Linking Contact Lists
I have two sheets I want to link but I am having an issue with the second sheet listing the linked cell data. The original sheet has assigned contacts that I want to link to my second sheet but when i create the link, the cell does not populate. I made sure the column formats and contacts lists were identical on both…
