-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Easily merging multiple sheets into one comprehensive sheet
This may be a very specific problem but I appreciate any help! I am collecting a certain set of data from people and what I would like to do is provide an Excel template for folks and once they return the template, upload their data into Smartsheet. I know that any import creates a brand new sheet. But I'd like all of the…
-
Equivalent to the "Link the selected tasks" from MS Project?
Is there any way in Smartsheet to have selected tasks linked in series quickly so that one will start after another? All I found is you can: - Manually type the previous row's number in the predecessor column of each task - Link tasks, two at the time, using mouse in the Gantt chart. But first you have to place the same…
-
Close current sheet
I really am not a fan of everything being on the left, but in "trying" to get use to the new layout I have yet to find a way to close the current sheet. I don't want to click on a new sheet just for the current sheet to fall to recent (too many already sit in there now), but I want it to close. Is there a way to close…
-
Conditional Formatting Question?
Hello! I'm very new to smartsheets and have been using them for probably 6 months and I have to create a sheet with conditional formatting where the date drives the coloring of the entire row. I've watched the video's and searched Q&A, however; I feel like my questions are specific to the work I'm doing. Is there any other…
-
Best practice sharing of links to forms
Hi I am ready to share several Smartsheet forms with my entire organisation (and some external consultants) - currently less than a dozen people - but growing quickly. I am currently the only licenced Smartsheet user. I only want to share the links to the forms, not their respective sheets, to the entire organisation. I am…
-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
How can I reapply a sort (or filter) without having to re-enter it from scratch?
Refreshing the browser page doesn't do it. It would be great if there was a "Refresh" button somewhere.
-
Open shared sheet from email message in the app, not the browser?
I'm wondering if there's a way for me to receive an email from a colleague where they ask me to view/update/edit a sheet, click on the 'Open in Smartsheet' button, and have it open in the Smartsheet desktop app - NOT in my web browser? I like to work exclusively in the app, and it's extra steps to close out of the browser…
-
Linking Cells and then Sorting Source Sheet
I am working on creating a master list of events, that pulls data from 2 source sheets. I worked out the linking, but when the source sheets are re-sorted it messes up my links on the destination "master list". Is there a way around this? The source sheets are not able to remain static pages and will be used and updated…