-
Help with a formula
Hi Everyone, I accidentally deleted a column that had a critical formula in it. I have recreated the column and am trying to show the last date that a step was completed. Below is my formula. I have copied and pasted the column headers to make sure they were the same, but I keep getting invalid column value. =MAX([Date of…
-
Can I trigger automations every 15 or 30 minutes?
This discussion was created from comments split from: set time for automation alerts.
-
INDEX Collect Max without blank
I am working on a formula to pull the row data from column "A", based on the criteria for row "B" and "C". The criteria is to look for the highest value in Column "B" and the same row "is not blank" in Column "C". In short index the row in column A, with the highest value in column B, that is also not blank in column C. I…
-
Authenticator app MFA for non-SSO login - now generally available!
October 30, 2025 Smartsheet users can now secure their accounts with authenticator-app multi-factor authentication (MFA), available at no additional cost for all plan types. With this update, users who sign in without SSO can verify their identity using trusted authenticator apps such as Microsoft or Google Authenticator —…
-
Sending Completed PDF from SmartSheet
Hello! Is there a way to send a completed PDF (that was auto populated from SmartSheet) via email to a contact list? I've tested this, and when I selected "Links to a sheet and specific fields" and entered "attachment", the email came through with a link to the sheet. I'm hoping to not send a link to the sheet, rather just…
-
Public sector - public records requests
Hello, we are a public sector organization, and any information entered into Smartsheet is subject to open records requests. Is there anyone else who has to search and provide data in Smartsheet to the public? If so, how do you provide that information? If it is a project plan, do you export to a PDF? Does that include the…
-
Formula Not working adding a 0
Hello I could use some help with this formula. Here is the formula I am using the bright yellow column to hold the formula. so you can see the results of that formula below =IF(ISBLANK([Initial Approval Date]@row ), " ", [Homeowner Approval Initial Status intake]@row + [Homeowner Approval Initial Status Intake 2]@row +…
-
Need To Be Able To Connect Power BI To Datatables
There is a need for Power BI to connect to Datatables in Smartsheet. Currently, Power BI only connects to Grids and Reports. In order for data from a Datatable to be accessed, a workaround must be used. One common workaround is a Datatable feeding into Grids, and then Power BI can access the individual Grids. This requires…
-
Collecting the most recent submission
Hello, I have set up a sheet in which a form will submitted with 4 columns; a specific label (from a dropdown list), and then up to three barcodes. On the grid I also have a hidden created date column. I am then wanting to create a separate sheet that collates the most recent barcode for each column for label for the day.…
-
Timeline View: Center on Today with Options for Visible Date Range
Timeline view is great. It has become our new favorite. One drawback is that it currently opens with the blue line (indicating today's date) way off to the left. Most of our projects have been in play for some time, and we like to see full bars in the visual, from the Start Date to the End Date. To accomplish this, we are…