-
Updating Rows on different sheet assigned to a user?
Dear All,new here, apologies if this has been discussed before, couldn't find anything. A question regarding the following scenario: Imagine a sheet (sheet 1) in which a user/department ads their requests assigning a task to a specific user/owner. Is it possible to update the sheet of the owner only when a task is assigned…
-
Custom Views
Hi everybody, this is probably not a new one, but I've not been able to immediately identify the right thread - therefore let's try again: We've started a new sheet with some intense collaboration, and everybody has his preferred view in the meaning of what to collapse and what to extend (preferences as well change over…
-
Keyboard Shortcut to attach a link in a cell?
Hi, Is there a keyboard shortcut to attach a link in a cell? I know that I can right click on a cell, then click on hyperlink to put in a link. It would be a lot faster if I could just use control K on my keyboard similar to outlook and excel. Any thoughts?
-
HELP! RYB Color Change Based on Dates
Hello everyone, I am currently using this: =IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red")))) Which is working but I try to add this: IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" And it doesn't work, I'm…
-
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…