-
Sharing Two Linked Template Sheets
We are rolling out a new process dependent on two linked template sheets to be shared into workspaces for each new project. When we share the templates into a workspace today, it appears to retain the links back to the original template in our template workspace. Is it possible to share two templates together and have them…
-
Service log / mileage tracker
I am using a form which has an individual input the current mileage of a vehicle every time they use it. This would need serviced every x amount of miles. I am wanting to set up an automation that will email a specific person whenever it's time to service the vehicle. I guess right now I am trying to find a way to do this…
-
How to write formula to display health based on baseline variance
Hello! I'm trying to write a formula that looks at the baseline variance and displays the health status based on greater than - less than criteria. We need the formula to read if variance is greater than or equal to "0", "green", if the variance is less than 0 but more than or equal to -9, "yellow" and finally if the…
-
Formula for separating names
Hello all i have a smart sheet that was imported from excel and need help. Currently I only have the full name in one cell (i.e) John doe. I want to have it where it will split the first and last name into the next two cells in the same row. And then I need it to take either the full name or the two separated names and…
-
Partial match with INDEX(DISTINCT(COLLECT(
Hello, I need to collect a list of values from my source sheet based on a search field (cell) in my target sheet. I have a very large subset of data that I'm pulling from, so I've divided it into 6 sheets to increase the speed of the lookup. Currently, I'm using the formula: =IFERROR(IF(OR(LEFT([Lookup Value]$2, 1) = "A",…
-
Relational Smartsheets
I would love to be able to connect sheets via a unique ID that is common to the sheets. Making sheets relational would be very helpful because we could have multiple related sheets, and avoid having to add common fields across all sheets. I'm maturing a program using SS, and if I had the ability to relate sheets it would…
-
Can I link a Smartsheet cell to a cell in Excel?
Is there a way to make links from Smartsheet to and Excel file? If so what is the best way to do this?
-
Within Sheet Link
It would be nice to be able to hyperlink from one cell in a sheet to another cell in the same sheet and back again.
-
Trying to Auto-update due dates based on actual completion date
Hi, I am new to smartsheet and I am finding it very useful; except that I can't figure out how to auto-update completion dates. For example, when I plan out my project, I put start dates, duration, predecessors and who it's assigned to so I know when the project should be done. Building a house may require someone to build…
-
No idea where to start?!?!?
Hi all! New to smartsheet and struggling with formulas. Here is the sheet I am currently working with (Sheet A) I want the column labeled DC AVG to populate the total AVG for all Doc Control lines, from the Date of Inspection and any dates prior. (I manually populated the existing data in DC AVG) Similarly for LP AVG, I…
