-
Formula help
I'm looking to write a formula that looks at cell A1 and if it contains "Sent" within the text of the cell, it grabs the number in cell B1 and writes it in C1. Example: Cell A1 = "Sent w Statement" Cell B1 = $100.00 I need C1 to populate $100.00 because A1 has the word Sent within the text Any assistance is greatly…
-
Notification with attachment
Hi, I have already set up the notification. In my Smartsheet, there are a few columns. One of column is "Mail Out". In this column, pre-set has two answer only: yes , no. In each row, there is an attachment of that specific building word file. So, as I create notification, if mail out column is "yes", email to mail room…
-
Formula: Look Up for two value
Hi, This one is pretty easy in Excel but I have no idea how to do that in SmartSheet. I have 3 columns in SS: Fruit, Brand and Price [Fruit]1 is Apple , [Brand]1 is ABC Ltd. [Price]1 is 100 [Fruit]2 is Apple , [Brand]1 is XYZ Ltd. [Price]1 is 50 [Fruit]3 is Pear, [Brand]1 is ABC Ltd. [Price]1 is 100 I want to have formula…
-
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…
-
Building Sheet to Alert Past Due Items
Hi All, I am trying to build a sheet that will track when items are turned in to our billing department. If the "turned in"date is past a certain date then I would like for the sheet to send a notification to certain people. The only thing is the "turned in" cell will remain blank until the date it is actually received. Is…
