-
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…
-
2 things. Referencing another sheet and trying to autofill information on separate sheet. Calculate
I have a sheet for a department and we are keeping track of material cost when an employee has to redo work. I have a graphics sheet with a weekly plan. I have one column with checkboxes to assign a task as a redo. When the box is checked, I want it to auto fill information on this sheet onto another sheet. I have tried…
-
Dropdown Formula
I have two columns, Status and Done. Status is a drop down with the options: Backlog, Working On It, Fast Tracking, Waiting on Someone, Done. The Done column is a checkbox, 1 or 0. I have already inputted the logic where when the subtasks are "done" (1), the parent automatically switches to "done". Here's that…
-
SUMIFS Formula
Novice Smartsheet User Trying to calculate the Sum of the numbers in a Column with Conditions from 2 other Columns. I keep getting the #UNPARSEABLE error. Condition: Sum up the numbers in Story Points when the "Sprint Name" column matches a certain value and "Team" column data matches a certain value. Both "Sprint Name"…
-
How to receive a reminder 7 days before due date for any task?
Hi Help, I want to receive a reminder 7 days before the Due Date of any of my task rows. I created the reminder that you can seen in the screenshot. It says: "Send ME a reminder 7 days before Due Date for this sheet", does it mean that it will receive the reminder any of my tasks or only if when all the task Due Date are…
-
Kanban visibility
Earlier I used Kanbanflow as my own personal kanban board for work, but as part of an effort to reduce the number of applications used (web and otherwise) I have started to use Smartsheet instead. It covers most of my needs, but I have a few simple wishes: * Are there any conditional formatting options for the kanban cards…
-
Lock Rows in Templates
Hello, I created a template that has some locked rows and cells in it. However, when I share it out the cells become editable? I would like them to be able to use the template but I would like to keep the formulas and some cells locked to prevent accidental deletion. Any help is appreciated.
-
Smartsheet Certification
Does Smartsheet conducts any type of Certification / assessment program to obtain excellence in Smartsheet usage.
-
Manage entitlements in a sheet!
I managed severals collaborators and for easier management I want to create several task in one sheet that will be assigned to different collaborators and I want each collaborator to allow see only the affected tasks. It's possible?
-
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…
