-
Sheet Editor rights
Hi everyone, I am on a Pro plan and have Admin right. I wanted to share my sheet with a colleague and give them edit rights. When I shared with them, Smartsheet told me that non Members will only have Viewer rights. However, when I shared it did allow me to select "Editor" and my colleague is also able to make edits. So…
-
Direct Email Approval Button for Smartsheet Automation Workflows
Integrate a direct approval button within the email notification itself that allows users to approve or reject requests without the need to transition to a web browser. This button would perform the same security checks and record the same audit trails as the current browser-based approval, ensuring that the process…
-
why wont my sheets group properly in my report
I created a report to try and get all my projects tasks organized and identifiable by project. I have the report groups by work breakdown schedule sheet, but for some reason my latest sheet will not break out in its own group. in the image below you can see the sheet that is grouping is the template sheet, but the P-0100…
-
Exporting Email Addresses from Smartsheet Contact List for SharePoint Integration
I have a Contact List column in my Smartsheet, but when I export the sheet to Excel, it only displays the full names of the contacts. For my SharePoint migration process, I need to retrieve and export only the email addresses from this column to ensure seamless item creation in the SharePoint list. I'm looking for the best…
-
Creating a formula that takes the total average of a row but excludes certain entries
I need to create a formula that take the total average of the row but doesnt include entries that are "N/A" "YES" or "NO" in the count. At present when ever those are entered the formula im using counts as "0" which greatly decreases the total percentage
-
Copy of Submission Not Showing All Columns
Does Smartsheet show all columns in the "send me a copy of my response" email from submitting a form? We used to show a critical piece of data in that our submitters would use for their records but now that column no longer appears in that email. The column used to display in the email, and has not been adjusted since the…
-
HELP WITH INDEX/MATCH ACROSS MULTIPLE COLUMNS WITH CRITERIA
Looking for formula help to accomplish the example below:
-
PTO/Absence tracker - how to deal with recurring events
I am creating a PTO/Absence tracker for our service technicians team. I have 2 separate input forms. - one to record/request PTO filled out by the service technicians themselves - another for Supervisors to book a service technician to a client site for a dedicated amount of time, - i.e., every MON for the next 3 weeks -…
-
Formula for Month in words
Hi everyone seeking for a help please I'm making a helper column formula for month I want the result as Month - day- Year (October 28, 2025) but it seems my formula doesn't work is there any way to have this formula or result as (October 28, 2025) =IF(ISDATE([Refund Deadline]@row ), MONTHNAME(MONTH([Refund Deadline]@row ))…
-
Sheet Filters on Reports
Sheet filters are extremely useful ways to view sheet information, it would useful to have the ability to select a sheet filter when developing a report to avoid having to duplicate the filter setup process.