-
'Helper' Column Management via New Column Type (or Side Panel?)
Many of us, if not most, use one or more helper columns to achieve the Sheet functions that we need. Good practice is to hide the helper columns (when possible) so that the sheet user isn't bombarded with noise. Unfortunately, hidden columns still appear while in Card View. My solution for this is to move all of the helper…
-
MM/DD/YYYY Date Format
Can we please add a MM/DD/YYYY date format to Smartsheet? I would like to feed this date into some DocuSign forms I need employees to complete, but they require a MM/DD/YYYY format in order for me to be able to utilize these dates.
-
Merged: Date Format
This discussion has been merged.
-
LOG() or LN() 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: Even though we can raise a value to an exponent,…
-
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…
