-
Accept ranges in the SUBSTITUTE function
After posting a laundry list of what I believe are simple ideas that I thought had already been requested, it was suggested that I post them individually on this idea board. While I think this idea is out there, I am unable to find it. My apologies if this is a repeat: Accept ranges in the SUBSTITUTE function. WHY NOT…
-
TEXT() function to format a number/date
After posting a laundry list of what I believe are simple ideas that I thought had already been requested, it was suggested that I post them individually on this idea board. While I think this idea is out there, I am unable to find it. My apologies if this is a repeat: Function that converts a value to text in a specified…
-
Automation isn't updating my email subject line as I had entered - what am I doing wrong?
Hello, I am having issues with automations not updating to show the custom subject line I entered for emails. I am not sure what I am doing incorrectly. Can someone please review the screenshots below and advise me? Thank you! Here is what I expected to see in my email: Here is what I got:
-
Highlight Changes in Report - read the changes from Sheets
Currently highlight changes tool in report only shows changes to cells made within the report, the report doesn't read changed made within the sheets. Request is for the report to read changes made to each of the sheets the report is connected to and show the highlights on the report. This feature would allow a wide group…
-
Transform rows in columns
It would be very useful to have a function or automation that allows to copy (based on a selection criterion), the values in the rows of a column and transpose them on a single row of another sheet, on a corresponding number of columns. Example: In a source sheet I have a column with an identifier code; I want to copy all…
-
Is there any way to hide a cell value within a grouping?
The two cells I have marked above in red are % calculations of the rows within their groupings. Is there any way to modify just those two cells to leave them blank? I use that column to calculate %complete of a project but I don't need to show the total % in the headers of the group. I also want to leave my groups as…
-
Count number of days in date range that fall in current week
Hi everyone, I have a number of project plans in Smartsheet and am trying to get a summary of how many task hours each person has assigned for the current week. The plans currently capture task Start Date, End Date, and number of hours required to complete the task. As some tasks will take multiple weeks to complete, I…
-
How to turn off "Track your Team's Workload" pop-up
Every time I open a sheet or report this pop-up message is there. How to turn it off?
-
How to transfer a sheet ownership from a user that is not in my organization?
Hello! I'm trying to take ownership of sheets I am the admin of, it gives me the error, "you cannot take ownership of this item because the current owner is not in your organization". My account was part of the parent company business plan, but now our company got their own plan, so my email is no longer part of the parent…
-
Why would you save a sheet as a template vs saving as a new sheet?
I have a master sheet that I plan to replicate multiple times retaining all configuration I have done ie workflows, attachments, predecessors. It appears that saving as a template and saving as a new sheet would retain all of those features. So what is the benefit of saving as a template vs saving as a new sheet (and vice…