Real Estate
Discussion List
- 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?
- 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 applyin…
- 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 R…
- 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…
- 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 …
- 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 (…
- When I sort rows, the formulas are not maintained: = SUMIF($[column_A]$7:$[column_A]237, "Received", [Column_B]$7:[Column_B]237)) gets transformed into this: = SUMIF($[column_A]$57:$[column_A]237, "Re…
- I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help …
- Hi Community, We are looking to connect with some fellow commercial real estate management (or similar) companies to share use cases and best practices. Anyone out there? Thanks in advance!
- Hello all, I'm using sheet summary to get rid of the top row on our master project list. Formerly, we used "=SUM(CHILDREN())" to add up all projects & sub tasks.The top row was only there to add every…
