-
INDEX COLLECT NAMES FROM 2 SHEETS TO ANOTHER SHEET
I HAVE (SHEET A) AND I NEED TO RETURN NAMES WHEN A MATCH OF IP ADDRESSES FROM SHEETS (DEL 1) AND (DEL 2) IS MADE.
-
Conditional Formatting not applying to entire column
I have a sheet where I want to highlight the entire column if there are blank cells within that column. My current rule is only applying to the first few rows even though the rule is set to apply to the column. I can't find any hidden data so I am not sure why the rule isn't being applied to the entire column.
-
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…
-
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…
