-
I have earned the Smartsheet Automagician Badge but I am not able to claim it
I have earned the Smartsheet Automagician Badge but I am not able to claim it.
-
Average Formula
I am looking to get a formula on my metric sheet cross referenced from the survey results sheet. I am looking to get it as a number average but also separately a percentage as well. One thing to keep in Mind is that each column is a question where they would answer a 1-5 option. On the metric sheet it is separated into…
-
Unable to Access Smart Sheet
Hi, I'm currently experiencing an issue with Repair Tracking smartsheet, which was created about three weeks ago. When attempting to access it, the page takes an unusually long time to load and eventually displays the following error message: Interestingly, other Smartsheets I’ve created are working fine—this issue seems…
-
Allow Column Linking with Auto-Number Fields in Table View
Description: In our grant process, applicants submit an application which is assigned an Auto-Number (e.g., FAC-00001) — this becomes their official Application Number. When a grant is awarded, recipients are sent a unique URL to a report form where the Application Number is prefilled. We would like to link the Application…
-
Attachments not sending in Email Alert
I've had a sheet set up where once the form is filled out an automation will create a PDF and then from there is will send out an email alert to the designated email box. The alert includes and documents that were uploaded during the form being filled out and the PDF that the Smartsheet creates. Its been doing this fine…
-
¿Smartsheet tiene problemas al enviar notificaciones con archivos adjuntos?
Configuré dos automatizaciones, una para crear un documento pdf que está configurada como en la primer imagen y otra automatización para enviar un correo electrónico de notificación que se active al agregar un archivo nuevo, esto ya tiene uno o dos meses que lo hice, pero la semana pasada no funcionó correctamente la…
-
Help with automation to find bad formatting
I have a sheet accessed by monkeys users who keep managing to muck up a currency column. They are either pasting in amounts from some other source or literally typing in the dollar sign followed by a number, or something. The result is reports that lose their currency formatting. Smartsheet seems to treat these bad entries…
-
DataShuttle Error
We are using Datashuttle to move data from an excel file in SharePoint to a sheet in Smartsheet. We received an error this morning. I looked at the workflow and the excel sheet but could not find any issue. I ran the workflow again and it completed. However, it wiped all the existing data out of the smartsheet. Thoughts?
-
Getting Unparseable error using IF function
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…
-
Please help to convert this Excel formula to a usable Smartsheet formula
Hi my colleague has imported an Excel spreadsheet and one of the formulas hasn't worked on import. Please could someone let me know if the following Excel formula can be converted into a usable Smartsheet formula? Here it is: =IF(B4<>"", ROW()-1, "") Many thanks, Lee