-
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β¦