-
Cell Linking Default in New Rows
Hi! I have a sheet with hyperlinks to training documents. I have another sheet which tracks when the training is completed for each person. I'm currently cell linking the training document to the other sheet but I need that cell link to be the default value when a new row is added. I tried VLOOKUP but only text appears and…
-
IF AND Statement for Color Statuses
I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Circles. My challenge is getting the proper formula/syntax for my Yellow Status. =IF([Status]1 = ???,…
-
How to get symbol to automatically update in destination sheet when it updates in the source sheet
I have rows copying over to a new sheet whenever column C is a certain name the box in column J is checked. Source sheet: Destination sheet: I would like a formula to automatically update the symbol in column L of the destination sheet to match the symbol in column M of the source sheet when the rows of columns A, B, C, D,…
-
How do I score out a survey and have it populate in another column?
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.
-
Time-Based Automated Workflow where date field is linked from separate Smartsheet sheet
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?
-
Can you Log a Cell In time?
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?
-
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 !
