Hi, When I try to cell link a date column it changed the date format from: dd/mm/yy to mm/dd/yy. The strangest thing is that it did not happen most of the rows, but some random ones. I have tried to refresh the sheet several times, but I still get the same date errors. Do anyone have any idea or suggestions in order to fix…
It would be even better if we could have the sender be a link in a cell. For example, I would like the email to appear it's coming from one of our Coaches as opposed to the Company.
So I'm using this formula to try and compare two "String" values. In this situation, some values in Column 2/3 will be numerical only and some will have text. I have a helper column checking that both are string values but it still won't match. I've tried with collect and contains too. I'm trying to pull the value in…
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
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…
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.
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?
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…
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…
