Real Estate

Discussion List

  • Formula
    In Formulas and Functions
    HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet   IF(K$1…
    33 1
    33 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Circular Reference / In Excel it works / SOLVED
    In Formulas and Functions
    This has been solved now :)  Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. S…
    253 6
    253 views 6 comments Most recent by Andrée Starå Formulas and Functions
  • # BLOCKED
    In Formulas and Functions
    Hi,  Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error.   Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken.  Right now, the only th…
    2852 5
    2.9K views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Formula for a future meeting date (after today)
    In Archived 2016 Posts
    Good morning - I have a series of columns with scheduled "future" meeting dates.  I want to populate one column with the date of the next scheduled meeting.  Have tried importing the formula which works in Excel over, but Smartsh…
    384 14
    Closed 384 views 14 comments Most recent by James Vandezande Archived 2016 Posts
  • Smartsheet in Commercial Real Estate
    In Formulas and Functions
    My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team.  Any suggestions on best templates, etc to use?
    155 5
    155 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • #INVALID OPERATION (SUMIF/SUMIFS to blame?)
    In Formulas and Functions
    The formula I'm trying to fix was not reporting our information correctly so I built a new formula in a test environment and it appeared to be working as intended only for me to find that when applying it in a live setting, the result was …
    92 1
    92 views 1 comment Most recent by Alejandra Formulas and Functions
  • Prorated Rent Schedule Formula Help
    In Formulas and Functions
    Need a formula to calculate what is due per calendar year when the rent amount changes year to year (midyear)   Any help appreciated! 06/01/19-05/31/20 Total Rent Due: $175,000 06/01/20-05/31/21 Total Rent Due: $200,000 Total Rent of 20…
    41 1
    41 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Drop down menu in one box only
    In Archived 2017 Posts
    I have a housekeeping template for 150 different properties, and I want a drop down list on the top left corner in order to identify the property when it is checked.  Can that be done for just one cell?
    2865 12
    Closed 2.9K views 12 comments Most recent by Andrée Starå Archived 2017 Posts
  • Routine reminder
    In Using Smartsheet
    Hello,  I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflo…
    21 1
    21 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Surveying Project - How to setup the structure of Smartsheets
    In Using Smartsheet
    I need to send out Architectural Survey team out to the field to survey the existing conditions of a restaurant. Information gathered is Electrical Information (Panel Size, # of Breakers), Equipment (Make Model and serial#), Condition of W…
    132 8
    132 views 8 comments Most recent by Andrée Starå Using Smartsheet