or Explore Discussions

Real Estate

Discussion List

• 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…
179 8
179 views 8 comments Most recent by Andrée Starå Using Smartsheet
• Sorting and conserving formula
In Formulas and Functions
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, "Received", [Column…
57 2
57 views 2 comments Most recent by Paul Newcome Formulas and Functions
• Best Formula
In Formulas and Functions
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 me craft the appropriate formula for th…
109 7
109 views 7 comments Most recent by Andrée Starå Formulas and Functions
• Commercial real estate best practices
In Using Smartsheet
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!
329 3
329 views 3 comments Most recent by Ginny Hager Using Smartsheet
• Number formatting in Sheet Summary
In Using Smartsheet
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 everything up. We moved this …
383 1
383 views 1 comment Most recent by Andrée Starå Using Smartsheet
• Formula Help
In Formulas and Functions
I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn th…
13 3
13 views 3 comments Most recent by Paul Newcome Formulas and Functions
• Project Management and Stakeholder Logs
In Using Smartsheet
We're using smartsheet to track a land acquisition project for a utility.  Each row will contain a contact, parcel features, a dates of progress.  We need a way to manage daily communication and updates.  We have considered using comments …
25 4
25 views 4 comments Most recent by Andrée Starå Using Smartsheet
• SMARTSHEET MERGE, HIDE SPECIFIC COLUMNS
In Apps, Integrations, and Add Ons
I built a Fund Allocation Request form that makes people produce PDF for printing at the end of the process.  To be able to produce the PDF, I use Smartsheet Merge.  But I ran into an issue of confidentiality.  Since the form is a finance …
34 5
34 views 5 comments Most recent by Andrée Starå Apps, Integrations, and Add Ons
• Formulas in Contact Columns
In Formulas and Functions
Please please please make it possible to use formulas in contact columns!  :)
184 2
184 views 2 comments Most recent by Andrée Starå Formulas and Functions
• Create a Smart Form to update a row data
In Using Smartsheet
How do I create a form to update a data? For example, I want to just click the row line and a form will pop up so I can update it and save rather than scrolling the line item from left and right to fill in the blanks. Hope anyone could he…
6362 7
6.4K views 7 comments Most recent by Lee Joramo Using Smartsheet