-
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…
-
Cash Flow Projection in Projects Sheets
Hi, I am using =IF(AND( ... )) to project in which month a disbursement will be made in a project planning sheet. Does anyone use an easier faster way of scheduling disbursements and depreciation? Regards
-
Future Date Calculation
Hello, I am trying to find a formula that will calculate out 90 days from a given date AND give the result as the last day of the month. The given date is Completion Date Estimate i.e. 10/31/2017 of a project and I would like a cost cut off date that is 90 days later on the last day of the month i.e. 01/31/2018. One…
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
