Support
Discussion List
-
How can I count distinct values under a same month?In Formulas and FunctionsHi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this …Answered - Pending Review 95 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Auto-populating a range of columns with a number based on dates in 2 other columns.In Formulas and FunctionsHi, I am having difficulty figuring out how to auto-populate a range of columns based on dates from 2 other columns. For example.. A contract's start date is Jan 2022 and its end date it October 2022. The value of the contract is 10,000 US…Answered - Pending Review 19 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
TimestampingIn Formulas and FunctionsHello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
Indenting on smartsheet causing calculation error- help?In Formulas and FunctionsHello, My organization uses smartsheet as a scheduling tool. We have a column that calculates what resource hours we have remaining for available scheduling (formula =((# of crew members * work days * work hours) - SUM(CHILDREN())) in my …
-
Access Issues with Smartsheets?In Using SmartsheetHi All, I have a paid license on Smartsheets and need to invite free users to certain spaces/documents to collaborate on work documents. However, when I share to users (both free and paid) with admin or editor access, they can't edit the d…
-
Creating a technology device loaning processIn Formulas and FunctionsGood day everyone. I am new to the community but not new to Smartsheet. Have been using at my company for a number of years now. My team has acquired a quite a few pieces of equipment and it seems that we are constantly loaning them out t…
-
Error when running out of CPU memoryIn Using SmartsheetNot really a question but more of a heads up. I had a sheet with almost the max rows and 6 columns and 2 references. Tried to add a column formula and my CPU ran out of memory. After the browser crashed I went back to the sheet and sm…
-
Formula not working in Smartsheet when data is populated from formIn Formulas and FunctionsI'm using a form to populate my Smartsheet. If N/A is selected from a dropdown list the completed column for that section should be checked (see below). I can get it to work when selected in the Smartsheet using formula =IF(([Loan Servicin…Answered - Pending Review 14 views 1 comment 0 points Most recent by Heather Duff Formulas and Functions
-
Can I set calendar view to open to today's date?In Using SmartsheetHello, Last week we noticed that our calendar view was opening to a date several years in the past (Aug 2015) rather than opening to today's date (which it had been doing successfully all of 2021). This sheet was completed in 2021 so ther…
-
Docusign Integration - Attach final Envelope as separate docs?In Apps, Integrations, and Add OnsWe are using a Template Docusign Envelope (with multiple documents in the envelope) and sending that via Smartsheet Generate Docs Docusign Integration. When the doc envelope is complete, the document attaches as one combined PDF in Smartsh…
