Formulas and Functions

Archives for July 2018

Setting up Days Outstanding
Hi all! I need to fix a column in Smartsheet. The column that says "# of days outstanding" does not always automatically fill for us. How do I fix this, do I have to put a formula in each cell? Also, smartsheet newbie here, I've been working in it for about a week, so I might need extra help. Thanks in advance! Laura
%Complete with dependencies enabled - Running into limitations :(
Hello all, Kudos to you all for such an active and friendly forum! I am new to Smartsheet and building an organization-wide task tracker for our accreditation and regulatory compliance for health plans. I have run into a snag on the build with respect to having dependencies enabled and calculating %complete. My department…
Formulas // How to set up one sheet writing to another
I created a project request form for one of my team members -- others on the team enter a request by filling out the form, and so the sheet becomes his workload queue. Another team member has a schedule on a separate sheet with some items assigned to the same resource. She asked if there is a way that if she selects his…
Formulae help....new to Smartsheet
Hi everyone, I am a new user to smart sheet. I need to do a sumif calc based on two columns of data being 'unticked' so I want to show the sum of i.e Column D but only if Column A & B remain unticked. When a cell is ticked it means that the work has been complete etc. Any help/advise would be greatly appreciated.
Bug: EXTREMELY bizarre behavior
After the release a little while ago, the first thing I noticed was a simple sum of 7 cells was giving the incorrect value. That resolved itself when I closed and reopened the Sheet for the second time. And then the KPI's I was working on went 'bonkers' and I noticed the attached values coming from a calculation on a cell…
Using formulas to determinate the status of a set of tasks
Hi community, I'm new on Smartsheet and I'm trying to make a formula to automatically calculate the status of a set of tasks (or subtasks). Let me explain my situation: I've created a main task, lets say "Project1" and it contains some subtasks as children. Next to this first column, I've got a column for the status (its…
Formula Assistance
I am attempting to automate my project list by scoring each project based on calculations in another sheet. I would like to create a "Project Score" based on drop-downs in my project sheet. Sum=Complexity*weight + cost*weight + impact*weight +resources*weight + value*weight. The values of each category and weight are in…
formula help
i need help with a formula please. my current formula looks like this.. =SUMIF(Stage:Stage, ???, [Job Value]:[Job Value]) i need an answer to the ??? please as it is a column that has a formula in it that relates to other fields and is a check box. if true then tick the check box. i am now wanting to sum the value of all…
COUNTIFS for individual weeks
I reached out for assistance recently about formulas to count specific projects for individual weeks. The formula assistance I received counts projects from today + next 7 then 13 days then 21 days. What the formulas are not doing is only counting from day 8 to day 13 from today. Here are my formulas...…
Determining an identifier based on parent/children and an additional factor
I have a sheet where I'm tracking IT initiatives, and some are considered Cross-Platform. Some Cross-Platform records have children and others do not. (See screenshot) Based on some reports I need, I have to identify Cross-Platform initiatives, but do not want to include the child initiatives. I created a column called…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

% in formula issue
Good morning, I have a column which named "% Complete". The next column, I wrote: =IF([% Complete]@row = 100, "Complete", "Not Complete") That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's…
Average of values if criteria is met in two other columns
Hello, I am trying to determine the average of values in one column (Days Open) if criteria in two other columns is met: (Date Closed) is from last month (Facility Name) is a specific dropdown option from this column I can calculate average based upon date closed being from last month, but adding in the second criteria…
Trying to create an on-call schedule with auto-calc'd dates
I am setting up an on-call schedule for all of the teams in the department. I want the start dates to auto-calc based on the prior row for the same team. I used AI to create a formula and it works. But when I went to make it a column formula, SS says that the format is not correct! This is the sheet. This is the formula in…

Formulas and Functions

Discussion List

Help Article Resources