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 …
API & Developers135tcalvey
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…
Formulas and Functions63KDub618
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…
API & Developers1587JeremiahHorstick
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.
Formulas and Functions1648Stradivarian101
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"
Formulas and Functions1291LouiseM
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…
I would like to know if it is possible
Check the Checkbox on multiple lines together
Using Smartsheet78Alma PM
Does 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…
Formulas and Functions44dplunkett79331
our 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 …
I 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 …
Formulas and Functions394Chann403
Been 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…
My 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…
Archived 2017 Posts87Michael.Baker
I 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:
Formulas and Functions73[email protected]
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 …
Using Smartsheet45Ginny Hager
I'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…
Formulas and Functions54Brad Huff
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…
Formulas and Functions12Derek Hermsen
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 …
Using Smartsheet45Jörg Schmidt Novum Hospitality
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…
Archived 2017 Posts408paul.whelan26901
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…
Formulas and Functions45jeffdimock
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…
Formulas and Functions152Ingrid O
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…
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:
Formulas and Functions128KaitlinH2
Can I attach a file from Citrix's Sharefile to my Smartsheets projects/forms/etc?
Premium Apps and Integrations119PardeeTiffany
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 …
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…
Formulas and Functions42seeble
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…
Premium Apps and Integrations32Sarah Irving
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…
Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet
i have build this formula in excel and its working fine, but i am getting error in smartsheet
Formulas and Functions23SBash
This has been solved now :)
Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. S…
Formulas and Functions111Oliver Lang
Getting this error in only on one sheet. There are about 20 sheets, but only one throwing the error.
Originally, the formula was more complicated, so I tried troubleshooting to see which function is broken. Right now, the only th…
Formulas and Functions713itsnotbroken