Real Estate
Discussion List
-
Email User Completed FormIn Using SmartsheetI 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…
-
Check the Checkbox on multiple lines togetherIn Using SmartsheetHello everyone I would like to know if it is possible Check the Checkbox on multiple lines together
-
Formula to check a box when date entered + 2 daysIn Formulas and FunctionsDoes anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours…
-
Updates to Master sheet automatically updates individual projectsIn Using Smartsheetour 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 …
-
Centrally Manage Drop Down Lists for Multiple SheetsIn Formulas and FunctionsI 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 …
-
Work OrdersIn Using SmartsheetBeen 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…
-
Is There Really No Built-in Log\NL Function?In Archived 2017 PostsMy 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…
-
SumIf with Date RangeIn Formulas and FunctionsI 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…
-
Project Approval Received / Master Project Sheet PopulatedIn Formulas and FunctionsI'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…
-
Sheet formula efficienciesIn Formulas and FunctionsHi, 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…