-
Hello, i need some help how do i connect the %complete column to the status column
for example if the status says in progress i want the %complete column to automatically say 50% can anyone help me?
-
How do I make my Smartsheet columns update when I update the Form
I'm brand new to Smartsheet Forms and I'm on deadline. I accidentally created a Form tied to the wrong Sheet. After realizing my mistake, I duplicated the original sheet and fixed the new column headers (which had populated when I created the Form, of course!) and went back to the original incorrect Sheet ... I THINK it's…
-
Can anyone please explain why my Mid formula is not working?
I am trying to pull the 5 digit number ID in the middle of this text string. My formula works for the ones labled CTV however for everything else it is an #Incorrect Argument. Any help would be greatly appreciated =IFERROR(MID([Campaign Name]@row, FIND("_CTV", [Campaign Name]@row) - 5, 5), MID([Campaign Name]@row,…
-
Dashboard Formatting, Displaying Data, and Cell Linking
I am stumped by formatting in the Dashboard. The first pic is how I would like to display the development schedule on the dashboard. It is very clean in comparison to the only way I have found in SS (2nd pic). Any suggestions on how I can get the better display on Dashboard? I would love for the data to be in SS so the dev…
-
Connect Smartsheet with MS Excel
Hi, Would any of you be able to point me in the direction of a video or simple explanation for how to draw in live cell data from a Microsoft Excel spreadsheet that is housed in MS Teams, please? I'd like to be able to take a revenue cell from an Excel sheet that is in a Teams folder (and is updated by a team that doesn't…
-
Cross-Linking Sheets
Hello, I am trying to figure out the best way to cross link sheets. Ideally, I would like to be able to match columns across sheets, but my sheets are too large to do so. Set-up: Main sheet (sheet #1) with thousands of entries and hundreds of columns. From sheet #1, I am only pulling entries that match specific criteria.…
-
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…