Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Real Estate
Discussion List
-
First post 11/25/19,Last post 12/08/19our company has multiple projects that have the same tasks, durations, and dependencies, but have different start and due dates and different assigned staff. We are creating a master project template that can be used as the starting point …Using Smartsheet315tcroxdale -
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions402KDub618
-
First post 09/27/19,Last post 12/04/19I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have …Formulas and Functions894Chann403
-
First post 11/19/19,Last post 12/03/19Been using Smartsheets for over a year with just some basic tracking sheets and task lists to share. Ready to make the jump into more complex sheets. I have 18 warehouse facilities across the country and trying to come up with a sheet to…Using Smartsheet232b.wick111871
-
First post 08/07/17,Last post 12/01/19My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in E…Archived 2017 Posts232Michael.Baker
-
[email protected] 36 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 11/19/19,Last post 11/20/19I created a project management financial sheet (client / projects / deliverables & invoicing). I am trying to sum the value of invoices between a date range (screen grab). This is what I thought would work: =SUMIF(DTI:DTI, AND(@cell…Formulas and Functions363[email protected]
-
First post 11/06/19,Last post 11/19/19I had started a community thread about incorporating smartsheets into our commercial real estate process. I have built several sheets, dashboards, reports for our team but would really like to connect with someone that could give further …Using Smartsheet182Ginny Hager
-
First post 11/11/19,Last post 11/12/19I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be cop…Formulas and Functions211Brad Huff
-
First post 11/06/19,Last post 11/07/19I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…Using Smartsheet251Shah_0614
-
First post 11/01/19,Last post 11/05/19Hi, I have a feeling that I should be using "@cell" or "@row" in a formula to make less calculations. Can anyone shed light on a better formula than the one I have started? Basically trying to determine if a date fall…Formulas and Functions115Derek Hermsen -
Jörg Schmidt Novum Hospitality 21 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 10/15/19,Last post 10/28/19Hi, currently my team (4 members) uses one excel file to save information about insurance incidents (task tracking with regularly action documentation f.e. what have craftsmen done, has insurance paid a.s.o). It takes a few month until …Using Smartsheet214Jörg Schmidt Novum Hospitality
-
Closed paul.whelan26901 52 views 5 comments 0 points Most recent by Andrée Starå Archived 2017 PostsFirst post 10/25/17,Last post 10/25/19I want to set up a recurring set of weekly meetings over a 3 year project on a single row. So far the only way I see to do this is to have a separate row for each meeting....painful. I can do a roll-up, but it graphically shows as a contin…Archived 2017 Posts525paul.whelan26901
-
First post 10/18/19,Last post 10/21/19I'm trying to move various spreadsheets from Excel to Smartsheet but I keep needing the DAYS360 formula. It is very common to calculate loans based on 360 day years so monthly figures remain constant (at 30 days/mo). I was very surprise…Formulas and Functions141jeffdimock
-
First post 10/17/19,Last post 10/18/19Hi all, I'm trying to populate an entire column on a sheet using both cross-sheet and in-sheet references. I'm trying to return a value according to the following logic: Looking for cells cross-sheet that contain "Opening Date&qu…Formulas and Functions331Ingrid O
-
First post 10/17/19,Last post 10/18/19I have a form to collect data from Property Managers for each of my tenants. Each column is a document with a yes/no that will be checked on the form if the Property Manager uploads the document. Also on the form is a URL to the Dropbox fo…Using Smartsheet161merrily
-
First post 10/16/19,Last post 10/16/19I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success. Here are a two that I've tried: =SUMIF(OR(…Formulas and Functions362KaitlinH2
-
First post 10/14/19,Last post 10/16/19Can I attach a file from Citrix's Sharefile to my Smartsheets projects/forms/etc?Premium Apps and Integrations271PardeeTiffany
-
First post 10/11/19,Last post 10/14/19Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …API & Developers273tcalvey
-
First post 10/04/19,Last post 10/04/19Hi, I have a form for users to report bugs in software (and I'm sure I'm not alone in that!). Users should be able to copy-paste a screenshot directly into a regular field in the form, instead of having to save the image and then upload …Using Smartsheet201Maarten
-
First post 10/02/19,Last post 10/03/19I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, cou…Formulas and Functions234seeble
-
First post 09/10/19,Last post 10/01/19Does anyone have a docusign/smartsheet "how to" instructions? I have tinkered around a bit but am having a hard time recreating a workflow in smartsheet labs. I think the issue is setting up my docusign template. Thanks in adv…Premium Apps and Integrations228Sarah Irving -
First post 09/30/19,Last post 10/01/19Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or…Using Smartsheet183SBash
-
First post 09/27/19,Last post 09/28/19HI 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…Formulas and Functions181SBash
-
First post 09/26/19,Last post 09/27/19This 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…Formulas and Functions206Oliver Lang
-
First post 09/23/19,Last post 09/25/19Hi, 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…Formulas and Functions565itsnotbroken
-
First post 11/21/16,Last post 09/23/19Good 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…Archived 2016 Posts3814Gerry McRobert
-
First post 08/22/19,Last post 09/22/19My 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?Formulas and Functions245Ginny Hager
-
First post 09/18/19,Last post 09/20/19The 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 …Formulas and Functions181RMRGSA
-
First post 09/19/19,Last post 09/19/19Need 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…Formulas and Functions171Ginny Hager
-
First post 11/25/17,Last post 09/19/19I 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?Archived 2017 Posts20312iclausen
