Real Estate
Discussion List
-
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…
-
import and consolidate daily changed excel file with SS sheetIn Using SmartsheetHi, 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 …
