Real Estate

Discussion List

  • 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…
    907 5
    Closed 907 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…
    81 1
    81 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…
    314 1
    314 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…
    103 1
    103 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(…
    192 2
    192 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?
    212 1
    212 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 …
    142 1
    142 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…
    113 4
    113 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…
    31 8
    31 views 8 comments Most recent by Andrée Starå Apps, Integrations, and Add Ons
  • Free Collaborator / Unlicensed User
    In Using Smartsheet
    Hi, 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…
    163 3
    163 views 3 comments Most recent by Andrée Starå Using Smartsheet