エンタープライズ向けに構築

Start date of the month for the previous 13 months rolling

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I wan...

Pulling data from one sheet into the sheet summary of another - is automation possible?

Home› Get Help› Smartsheet Basics ... Pulling data from one sheet into the sheet summary of another - is automation possible? ... SL RN ✭ ... I am using Smartsheet to conduct and keep track of seve...

Checkbox not shown in field which does not allow me to check a box

I created a new Smartsheet from a template. ... I added a column for a check back and it worked fine. ... I even created a second column with a checkbox that also worked. ... After I continued to m...

Sales pipeline with sort (need child/parent row stays together)

I have a sheet that has child/parent rows and which I can sort by dropdown list order (see below pics) ... So here are my questions: ... 1.) how can I have a report where it only shows the current ...

Multi Select Dropdown, Adding Values

I created a column with a multi-select dropdown. ... I would like to add values for each selection and then create a formula to add the values together. ... Example: ... If someone selected Effort,...

Sending forms to collaborators

Hi, I send forms to collect data from lots of collaborators and the system has worked very well. ... It appears that anyone without a Smartsheet account is now asked to watch a video and sign up fo...

Certification Exam

I took the certification exam back in January as an "early adopter" for my team. ... Some of the other members are now getting around to taking it and asked me about the practical component (part I...

How to create a report with task finished in last 5 days

I am trying to create a report that tells me how many tasks have been completed in the last 5 days. ... Currently, I have a reporting field called child to make sure I only show children tasks and ...

Portfolio Metrics Formula

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... Hi ev...

Formula Help: Return Month from "Date Created" if "Date Added" is Blank

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I nee...

Calculating Percentages Formula for Multiple Rows?

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... Is th...

Contact Groups

Is there a way to tag contact groups in conversations? ... Same thing for tasks. ... We have some groups that are large that it would be easier to @ the group instead of 5+ individuals. ... This wo...

Report with both Null and Not-Null values

Formulas and Functions ... Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem. ... Home› Get Help› Formulas and Functions ... I hav...

Deleting Duplicates by Column Formula