-
Correctly nesting an IF formula for automated flagging in row with unchecked column, and passed date
Hi there I am new to Smartsheet. I've learned how to write basic IF() formulas successfully. Now I am trying to create a formula to turn a flag on if the checkbox column is unchecked. Also, I only want the flag to turn on, on or after a given date. The flag type column is called Arrived? And checkbox column is called PM:…
-
New Notifications to non Smartsheet users
HI Guys, i have just tested this amazing new future of allowing a non smart sheet user to get notifications i was trying to set it up for clients To receive a notification when i updated a new payment into their Receive payment sheet It works amazingly just 1 problem the attachment of the row which in my case is the…
-
Notification problems
I was trying to have a notification sent to the "Responsible Party" assigned to that cell so they would receive an email when the row was assigned to them. It seems straight forward but it is not working for me. (I used another email address I have as the responsible party for testing purposes) what did I do wrong?
-
New! Row Edit Multi-Pane View - will this help your SmartSheet efficiency?
Hi, why always separately open the multiple edit dialogue boxes for data linked to a row -when you could have one click optionally open all all simultaneously in a Multi-Pane popup window! - Row Edit, Discussions, Sharing, Attachments, (PLUS even a new feature - part of the multi-pane window showing an email thread linked…
-
Creating a Cash Flow Model
Dear Developer I would like to know if any one be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I…
-
Notification sent on selection of certain criteria from drop down menu
I have a sheet with a simple drop down menu. I have a notification set up for my accounting department. They only want to be notified once the "accepted" choice from the drop down menu is selected and not the other 4 choices. Is this possible. Thanks in advance Louise
-
Edit Column Properties
Hi, I have a spreadsheet to record building name, building manager and support staff assigned. Each row represent one building. After I import excel to smartsheet, I try to change the column properties of building manager from text/number to contact list. However, on the screen, it requires me to enter name or email…
-
Creating a Cash Flow Model
Dear Developer I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers…
-
Can I remove the 'login' link when sending a row by email
We are using a smartsheet to create and sending accommodation quotations. If I send a row of data by email, the recipient gets a nice view of the data in a vertical format, but sees a 'login' link at the top of the email. This is confusing for the recipient as they cannot login to the smartsheet account - we do not want to…
-
Customized notification
Hi, Community member: I have already set up the notification and successfully. However, I want to add one more feature. Currently, my smartsheet has several columns: building, building name, building manager, reports delivery method (e.g., mail/email/courier) , mailing info (who should receive) and email info(who should…
