Real Estate
Discussion List
-
FormulaIn Formulas and FunctionsHI 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…
-
Circular Reference / In Excel it works / SOLVEDIn Formulas and FunctionsThis 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…
-
# BLOCKEDIn Formulas and FunctionsHi, 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…
-
Formula for a future meeting date (after today)In Archived 2016 PostsGood 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…
-
Smartsheet in Commercial Real EstateIn Formulas and FunctionsMy 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?
-
#INVALID OPERATION (SUMIF/SUMIFS to blame?)In Formulas and FunctionsThe 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 …
-
Prorated Rent Schedule Formula HelpIn Formulas and FunctionsNeed 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…
-
Drop down menu in one box onlyIn Archived 2017 PostsI 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?
-
Routine reminderIn Using SmartsheetHello, 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…
-
Surveying Project - How to setup the structure of SmartsheetsIn Using SmartsheetI 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…
