-
Custom Templates for Automated messages from Smartsheet
We would like to use a custom template based around our company when sending automated notifications from Smartsheet. We have specific templates we use when sending email notifications and would like to incorporate these into our Smartsheet notifications. This will allow us to utilize Smartsheet for all our company alerts.
-
Nested IF with IF(OR statement not working
I am trying to set dates based on country - the US, CA, and UK are singular, whereas the EU, APAC, etc, have many countries (using OR). =IFERROR(IF(OR(GEO@row = "US"), [Req. ETD Date]@row + 31, (IF(GEO@row = "CA"), [Req. ETD Date]@row + 55, (IF(GEO@row = "UK"), [Req. ETD Date]@row + 56, (IF(OR(GEO@row = "EU", GEO@row =…
-
Index Join Collect - gather list
I want to create a formula that gathers a list of zones by identifying the area. Column A is the area, Column B are all the zones that are under each area. In the related form, the person enters Column A area and adds a zone to Column B that is under that particular area. As the list of zones builds with each form issued,…
-
Calendar View
So i have a Work Space Calendar i have made but its Within a Workspace already for everyone to see. but when other Open it for the first time it opens as a Grid View. and everyone needs to Switch it to Calendar View for it to look right. i have Tried the Publish and changed everything to Calendar View but i think that is…
-
Help with a potentially complicated formula.
Looking for a formula to do the following with these two sheets. Thank you
-
I'm struggling to get a negative number for accounting!
So I have incomings and outgoings but I cant find a formula to turn my outgoings into negative numbers? The bank payment column is a drop down so when I select an outgoing I need my figures to become negative, what formula do I need to use?
-
Weekly Report
Hello Smartsheet folks, Does anyone know how I can create a report that only show data results every week? I have a data sheet/report that shows what store was complete, their unique information and the date their installation was complete, for the entire month. From this data sheet/report, I want a weekly report that only…
-
IF formula with multiple options
Good morning- Wondering if someone might be able to help me with this. I have a dropdown list column that has three options. If option A is selected, I want to automatically populate another column in the sheet with a specific message, but if option B is selected, I want to populate that same column but with a different…
-
Formatação automática inserção de dados formulário
Quando envio dados ao smartsheet por meio de um formulário, ele está formatando dados de uma lista suspensa para milhares, o que não deveria ocorrer visto que são ID's/Serial Numbers. Até um tempo atrás isso não estava acontecendo e do nada isso mudou. Como impedir isso?
-
IF formula
Hi Folks looking for simple formula hoping someone can help Trying to add in sheet summary Total cost [ sum of all amounts in last column] if Purchase order status [ first column] is 1.1 Any suggestions welcome is it better in sheet summary , reports etc Thanks in advance
