Real Estate

 

Discussion List

  • Calculate the time between two dates by days, hours and minutes
    In Formulas and Functions
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    2654 26
    2.7K views 26 comments Most recent by Julie Barbeau Formulas and Functions
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1348 5
    1.3K views 5 comments Most recent by L_123 Formulas and Functions
  • RTF in Dashboard Widget
    In Using Smartsheet
    I downloaded an example dashboard which tracked multiple projects.  Looked good and decided to build my dashboard to match example.  Example dashboard has a Rich Text Widget which has multiple formats within.  However when I try to use the…
    503 12
    503 views 12 comments Most recent by Roland Horwood Using Smartsheet
  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    4560 30
    4.6K views 30 comments Most recent by JeremiahHorstick API & Developers
  • Pasted text from OneNote to Smartsheet cell appears as an image?!
    In Using Smartsheet
    Hi, When you paste text from OneNote into a cell in Smartsheet it appears as an image.  This is so annoying.  See attachment. The only workaround is to paste the text into a web browser or word document, then copy/paste that back into Sm…
    277 6
    277 views 6 comments Most recent by Sky Page Using Smartsheet
  • Count If Current Week
    In Formulas and Functions
    Hi Everyone, I have some daily data with dates and I want to get the week to date numbers off that data (Monday - Sunday of current week). I know countif is needed but I'm not sure how to go thru the rest. Your help is appreciated.
    4024 21
    4K views 21 comments Most recent by Paul Newcome Formulas and Functions
  • Commercial Real Estate
    In Using Smartsheet
    I 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 …
    94 3
    94 views 3 comments Most recent by Sarah Irving Using Smartsheet
  • Document Management Systems
    In API & Developers
    Hello 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 …
    302 4
    302 views 4 comments Most recent by Brianne Laird API & Developers
  • Volunteer Allocation
    In Formulas and Functions
    Hi 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…
    123 3
    123 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Email User Completed Form
    In Using Smartsheet
    I 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…
    Accepted
    185 3
    Accepted Answer 185 views 3 comments Most recent by Andrée Starå Using Smartsheet