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

Charts - Value over Time

I am trying to create a chart which displays a contingency fund remaining balance over time. ... Here is what I was able to produce: ... This looks great, but the x-axis(time) is not to scale. ... I am pulling from a sheet that contains all instances of contingency fund draws, but they will not occur at a regular interval.

10,000ft connected to Primavera P6

We use P6 as our Project Management application, and 10,000ft to manage scheduling of specific resources working on projects. ... Since we do hundreds of projects each year, I am looking for a way to automate getting project info updates from P6 into 10,000ft (start date, end date, etc.)

delete data from a cell without eliminating the formula

09/30/20 in Smartsheet Basics ... Is it possible to delete data from a cell without eliminating the formula? ... Tags: ... Unfortunately, it's not possible at the moment, but it's an excellent idea!

Return 1st, 2nd, and 3rd non-blank value per row

Formulas and Functions ... 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

COUNTIF Cell Value is Negative

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 don't yet see this question put out there, so here we go:

Resources

With guidance from the Smartsheet Customer Success team, establish your knowledge and skills with a thorough understanding of all the resources available to you!Learn how to leverage the right ...

CountIfs 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 ... I am trying to get a percentage for a dashboard to work.

Form History

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'm curious if there is any way to see history of a form.

COUNTIF cells match in different sheets

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 am struggling to get a count if cells match when referencing different sheets.

Count Ifs Specific Year

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 am trying to Count Ifs the word "Bidding" appears in a column based on the Bid date being in 2024.

What is the best way to connect "predecessors" in SmartSheets to Jira?

Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector. ... What is the best way to connect "predecessors" in SmartSheets to Jira?

Average only parent 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 ... I have 4 parent rows and each row has 3 child rows.

How can i do a unique Project manager formula in my sheet summary

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 ... 01/20/21 in Formulas and Functions

Count/Count If 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 ... I have a sheet with a date column and another column with a number in each cell (e.g. number of tasks for the particular day/date) - see screenshot.

Count Columns in data sheet to appear in calc sheet.

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 ... Count Columns in data sheet to appear in calc sheet.

How do I reference a whole column in the count function?

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 ... How do I reference a whole column in the count function?