Real Estate

Discussion List

  • IF FORMULA TO PUT AUTOMATIC STATUS
    In Formulas and Functions
    I would like to know what can I do to put automatic status for my monitoring sheet?  There are 3 status:  In Transit, Cancelled and Delivered.  I want to know if its possible that when the requestor input the delivery date (refer to the sc…
    82 6
    82 views 6 comments Most recent by Andrée Starå Formulas and Functions
  • Send notification without access to sheet
    In Using Smartsheet
    I am wanting to create a workflow that will send a notification to a contact listed in a row without allowing access to the sheet itself.  Specifically, when I receive a notice to vacate from a resident in one of our apartment buildings, I…
    395 3
    395 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Dashboard formula counting rows within date range
    In Formulas and Functions
    First post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard.  I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is no…
    93 3
    93 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Radar Charts
    In Using Smartsheet
    Hi, I think the graphs implemented last year were an excellent and needed set of features.  I still however have to use PowerBI for some of our charts.  This is problematic.  Can we get Radar Charts into the Graph Types?
    264 1
    264 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Automate a rent increase on certain date
    In Formulas and Functions
    I am trying to automate a rent increase on a certain date. I have a table with Tenant ID, Rent Increase Date, New Rent amount. I would like to reference this in another sheet, so that when the rent increase date arrives, it will return the…
    31 3
    31 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Date Format
    In Archived 2017 Posts
    Hello,   When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This data will then be pulled…
    2067 15
    Closed 2.1K views 15 comments Most recent by Kara Lumley Archived 2017 Posts
  • Using COUNTIF on a Range with Cross-Sheet References
    In Formulas and Functions
    I am attempting to use a COUNTIF formula on a column of cells that have VLOOKUP formulas pulling in information from another sheet.  The COUNTIF formula returns a #NO MATCH. When I copy/paste the VLOOKUP info into text only, the COUNTIF f…
    71 2
    71 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Dashboard: Loss of images that existed on my report
    In Using Smartsheet
    In our Smartsheet set up, we provide photos of users that appear with their name (in assigned tos, owners, etc). These photos will appear in sheets, reports, etc.   However, when we use a given report or data source in a dashboard, the i…
    81 1
    81 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Sumif across Children and Grand Children
    In Formulas and Functions
    Dear Community, I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value. Here are the formulas I have been trying:   SUMIF($[Payment Status]5:$[Payment Status]50), "Received&…
    193 8
    193 views 8 comments Most recent by Paul Newcome Formulas and Functions
  • Gantt rollup for multiple projects
    In Using Smartsheet
    We are trying to rollup multiple project sheets that have tied in metrics. The gantt view is not allowing us to have the dependency arrows on our rollup. Do you have any suggestions how to create this? We have multiple tasks on our project…
    444 1
    444 views 1 comment Most recent by sean59916 Using Smartsheet