-
Does anyone know out there, how I can copy and paste a list of contacts for approvers?
Does anyone know out there, how I can copy and paste a list of contacts for approvers?
-
Using Forms, I want to include a link to another Smartsheet that is accessible via cellphones
Hello! Employees report their absence using a Smartsheet "Attendance" form, usually from their cellphone. I've created a "picture map" on a separate Smartsheet grid to show new employees the different buildings and managers and linked it to my form (it's pretty confusing with 5 of the buildings on the same street). The…
-
Merging a large amount of data from multiple sheets
Hello, I am hoping I can get some assistance with this. We have a Work In Progress report that is currently housed in google sheets, but we are looking into moving it over to smartsheet. In Google Sheets, the report has 4 different tabs. All 4 tabs are in the same order (by project), but house different data on the…
-
How can I link my sheets in Workspaces?
Hello, I'm wondering if there's a way to link my sheets in workspaces, we want something that will transfer onto the other sheets or have something in red trigger another sheet into auto generating it there to know what task needs to be completed. Should i just do a master sheet and that will link them? or how can i go…
-
Reset date on a recurring task
Hi - Is there a way to automatically reset a date when a task is complete? So when a task is done I click the check box and it will automatically reset the due date to the next business day on daily recurring tasks. Thank you!
-
Call
Hallo , I have different Nrs of sheets, Example.. 1, 2,....... , then i referred these sheets to main sheet called Main . I used Vlook and also tried Index/Match ,,, Everything works perfectly..... The problem is whenever customer creates new sheet( in my case Example . 3), they have to go to Main sheet and they have to…
-
Looking for a project correspondence solution
Good Morning Gurus! I've been asked to assist in the design and development of a project correspondence solution in Smartsheet. Personally I think SharePoint is a better fit, but they are on a very old version of SharePoint which will be upgraded to SharePoint Online in the next year. They don't want to wait for that, and…
-
help with formula's
hello new to smartsheets. i am looking to make a V lookup that will crosslookup on 2 sheet to tell me if it is on that sheet or not. this is what i come up with so far. =IFERROR(IF(ISBLANK($[Cable Name]@row), VLOOKUP($[Cable Name]@row, {K2 Power/Motor Cable List Tracker Range 1}, 1, false)) Motor, 0) I would like it to say…
-
SmartSheet Proofing links in MS Teams
Hi, I am trying to figure out a way to share links to proofs with approved editors in MS Teams. Right now, when I share links to a SmartSheet proof in MS Teams, the proof is view-only without the editing functionality. This is strange because the people I am sharing it with in Teams have been given editor permissions. Any…
-
dashboard gantt chart showing blank months
Hello, in my dashboard with a gantt chart, it shows the months that are blank, it starts in december 2021 and it goes all the way to 2022, I am not sure why it shows all these months if in the report don't even come up. Please help Thank you
