-
Subtracting Velocity Point(s) Value in row, and in column
I am wanting to create a column in my project workflow that will show how many story points I have remaining for the sprint or release. I have a snap shot of the sheet that shows Checkbox column for Started and Done, a Status column based on checkbox on or off, Velocity(story points) and remaining velocity. Hidden is the…
-
Merged: Is it possible to simplify the process to set-up a reoccurring task?
This discussion has been merged.
-
Tracking actual time in percentages, reporting in hours?
A component is adamant about tracking their actual time on projects based on percentage of an 8-hour workday, but senior managers want to see actuals based on hours. Is there a formula or other way for staff to enter a percentage and convert that to hours for reporting purposes?
-
IFS formula and adding number of days
How to convert this Excel formula into Smartsheet =IFS(ISBLANK(C3),"",E3="Product1",C3+30,E3="Product2",C3+15, E3="Product3",C3+30,E3="Product4",C3+30) I would appreciate your help. Thank you:)
-
Conditional formatting someone changes a cell that has drop down list
I am trying to apply conditionally formatting rule to highlight cell changes. These cells have drop down options to choose from. When the drop down option changes, I need the cell to highlight.
-
Day & Week before reminder
Hello, I would like to set a day before and a week before reminder that references a Due Date column I have in my sheet and only triggers on weekdays. Is there a way to do this? Thank you for your help!
-
automation for adding date?
So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong. I have a grid of teams and members where I keep track of which members are complete, I'm trying to track when a 70% or more of the team is "done". I've made…
-
Wrike/smartsheet Integration?
One of our departments made a decision to get Wrike last year. They've told me it can integrate with smartsheet- but I haven't found anything that explicitly gives how-to kind of guidance or is it just an API kind of thing where we have to pretty much develop it. I hope to show the team all the great new functionality we…
-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
Timestamping
Hello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew