-
Checkbox Formula
Hi there, I have created a document designed to check off whether or not we have received scores back from our partners using a column of check boxes. I need to input a formula that counts the boxes that have been checked off versus the total number of check boxes (ex. Scores Received: 4 out of 20) Can someone provide a…
-
Can a web form user make an update without sheet access?
We have the following request. A department has a sheet to track requests from different people/departments. The sheet has request need, type of request, requester name, due date, and many other fields. Submitters use a web form to submit the request. After submitted, they may need to change or update information. So they…
-
Formula is changing after a date sort
Once my data is in the appropriate cells I want to perform a sort by Due Date. When I do this the formula =SUMIF($Equipment5:$Equipment171, "VUTEK", $Tue5:$Tue171) Changes to =SUMIF($Equipment16:$Equipment171, "VUTEK", $Tue16:$Tue171) Thus not including any data from rows 4 thru 15. I have locked the row with the formulas…
-
Defining a range using a variable as the row #
Hi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell? For example, rather than "15", something like =SUM([Column1]Row:[Column4]Row) where "Row" could be sourced from the…
-
Multiple SUMIF within a single cell?
Hello, I'm trying to build a template which would allow vendors to log hours against a project and automatically calculate a cost for each task. This calculation looks at the name of the individual reporting hours along with the listing of approved hours for the task then multiplies it against that individual's hourly rate…
-
JIRA import duration problem
I'm using the JIRA connector for Smartsheet. I'm attempting to use our "original time estimate" field from JIRA for the "duration" column in Smartsheet. It looks like JIRA sends the time estimate information in minutes, but Smartsheet is treating it as days. So, a task that was given a time estimate of 16 hours in JIRA…
-
Automatic Capabilities
Hello, I am looking for a little direction. I am new to smart sheet and went through basic capability trainings etc. However, I am looking for assistance in having a smartsheet automatically move information down and date it. Quick reference to help better understand my question. I work for a commercial real estate…
-
Building A Sheet That is Agile Velocity Focused
It won't let me hyperlink a copy of it but here is the URL for those who trust I'm not trying to do anything scary. https://drive.google.com/file/d/0B8APP67r815BaVdmRkxrRlVKRDA/view?usp=sharing So this creates a gant shart that shows them waterfalling off one another (but only shows where they end and not begin) It also…
-
Combine IF formulas in one cell
Hello, I'm trying to create a %Complete column based on a drop down list column called "Status". For example, I'm looking to combine these formulas into one cell, then copy and paste to all other cells in the same column. I'm very new at this and cannot figure it out. If there is a better way top accomplish what I'm after,…
-
Best "infrastructure" columns for portfolio reporting
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date). What other hidden columns do people include in…
