-
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 ))…
-
Referencing a sheet that has non-working days
Hello. I need help please. I am working on a Smarthsheet schedule where I need to define the calendar (ie exclude public holidays and our annual construction builders break) without enabling dependencies because that messed up my sheet previously. I have a separate sheet that has a list of non working days. My formula is a…
-
Expand The Manage References Pop-Up Menu
When managing references in a sheet, the menu that pops up to begin editing/duplicating/deleting cross-sheet references is incredibly hard to work with. The box that pops up does not allow the user to expand the bounds of the menu - vertically, horizontally, or diagonally. Ideally, building the menu out with functionality…
-
MS Power Automate Get Last Row of Data
The desired flow is: Smartsheet form is completed which includes three key pieces of info: Name, Email, Waiver This creates a new row in a Smartsheet A Power Automate flow is triggered where it checks specifically the Waiver (which is a dropdown either needed or not needed). If needed, the flow continues. I built an…