Formulas and Functions
Archives for July 2018
Discussion List
-
Setting up Days OutstandingIn Formulas and FunctionsHi 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,…
-
%Complete with dependencies enabled - Running into limitations :(In Formulas and FunctionsHello 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 bu…
-
Formulas // How to set up one sheet writing to anotherIn Formulas and FunctionsI 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…
-
Formulae help....new to SmartsheetIn Formulas and FunctionsHi 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 …
-
Bug: EXTREMELY bizarre behaviorIn Formulas and FunctionsAfter 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…
-
Using formulas to determinate the status of a set of tasksIn Formulas and FunctionsHi 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 cont…
-
Formula AssistanceIn Formulas and FunctionsI 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…
-
formula helpIn Formulas and Functionsi 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 an…
-
COUNTIFS for individual weeksIn Formulas and FunctionsI 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 onl…
-
Determining an identifier based on parent/children and an additional factorIn Formulas and FunctionsI 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 initia…
