Real Estate

Discussion List

  • import and consolidate daily changed excel file with SS sheet
    In Using Smartsheet
    Hi, 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 …
    Accepted
    134 4
    Answered ✓ 134 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Gannt Chart - multiple milestones on the same row
    In Archived 2017 Posts
    I 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…
    1084 5
    Closed 1.1K views 5 comments Most recent by Andrée Starå Archived 2017 Posts
  • DAYS360 Formula
    In Formulas and Functions
    I'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…
    94 1
    94 views 1 comment Most recent by Alejandra Formulas and Functions
  • VLOOKUP cross-sheet, if the search value's parent = @row
    In Formulas and Functions
    Hi 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…
    359 1
    359 views 1 comment Most recent by L_123 Formulas and Functions
  • Checklist Form to Upload docs to DropBox
    In Using Smartsheet
    I 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…
    129 1
    129 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • SUMIF(OR(???
    In Formulas and Functions
    I 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(…
    220 2
    220 views 2 comments Most recent by KaitlinH2 Formulas and Functions
  • Citrix's Sharefile and Smartsheets
    In Apps, Integrations, and Add Ons
    Can I attach a file from Citrix's Sharefile to my Smartsheets projects/forms/etc?
    256 1
    256 views 1 comment Most recent by Andrée Starå Apps, Integrations, and Add Ons
  • Copy-paste an image into a field in a webform
    In Using Smartsheet
    Hi, 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 …
    180 1
    180 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • If with dropdown list
    In Formulas and Functions
    I'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…
    124 4
    124 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • Docusign *Help Needed*
    In Apps, Integrations, and Add Ons
    Does 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…
    35 8
    35 views 8 comments Most recent by Andrée Starå Apps, Integrations, and Add Ons