-
Smartsheet and Microsoft Teams
Our company has used Slack. I was able to automate (through Zapier) the following: When a new row was added to a particular sheet in smartsheet, a new message was posted to a particular Slack Channel. We just switched from Slack to Microsoft Teams. Does anyone know of a way to create a similar automation? (Zapier doesn't…
-
Circular / Blocked Reference (Vlookup)
I have a problem with 2 sheets reading each other’s data through a VLOOKUP. The same problem was posted on May 30, 2018 by scott.barrett. Obviously it is not solved. My sheets also work perfectly for periods of time, and then start returning #circular or #blocked data without any changes to the sheets in almost every 2…
-
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.
