-
Direct link to status in automated email
Hi community, Is there a way to include a link in an automated email that allows the receiver to mark a task as complete directly from the email, without having to open the sheet? Thanks! Louisa
-
Formula and automatic hyperlink cell back to other sheet
In a sheet, we have a column formula taking a value from another sheet using 'reference another sheet' we would like it to create a hyperlink back to the other sheet where it took the value from. How this is helpful: we have a vendor portal where our vendors send in their invoices via a form to a sheet, then in one of the…
-
Is anyone else still having "random and intermittent" issues with cell links not working?
We have been having issues with cell links not updating since early October. Smartsheet support and pro-desk say they are working on it and then close our support tickets. Does anyone have any more information on this? We still have issues, but no one is talking to us.
-
Sheet to Sheet Cell Updates
I have a sheet with a status column. I would like to have the statuses in that column automatically updated based on when users make their updates in three other sheets. I thought I could use a workflow but I don't want to update the full row from sheet to sheet, only the cells in the status column. What is the best way?
-
Any solutions or workarounds to dropdown/cell-linking issues?
Hi everyone! It's a bit of a wall of text ahead, so apologies in advance and many thanks to anyone who dares read it. I’ve got a bit of a beast of a project I’m working through and I’m hoping y’all would be able to help me work out some of the pain points I’m running into. Some of them could probably be alleviated with…
-
Trying to consolidate specific rows from multiple sheets into one
Hi, I currently have 11 project plans and I would like to consolidate specific rows (e.g., rows related to a specific system) within those plans to a master plan, where I would add additional columns to edit. I looked into reports and linking cells, but these don't seem to do what I need. The consolidated report should be…
-
PMO Project Intake Sheet & Project Metadata
Hi, I'm using the PMO template to create the intake sheet and metadata. I see where in step 1B you can edit this column. What are people editing this column to say? Does it has to still be a drop down? What if I don't have an edit, can it just be deleted? I'm thinking I can't based on the note below.
-
Latest Comment in Cell
Is it possible to reference the latest comment on a row, in a cell? And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opposed to opening up the comments or manually updating the cell to reflect the latest update.…
-
Joining two columns together for rows that match criteria
Hello, I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet. So far we have =IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", ")) And get Data2, Data2,…
-
How do I take information from two sheets and auto populate into a third sheet?
I am trying to set up this smart sheet where it has a entity that someone can select from a drop down menu. Once they clicked any entity I had it V lookup from another sheet and it would auto generate the address for that entity from a different sheet into the cell next to it. I figured out how to do this part. I am…
