-
Health Bubble Turn Colors when Status is Updated
Hello, I am new to Smartsheet. I am trying to get when I change my Status to "Not Started" I want the Health bubble to automatically turn grey. And when I change my Status to "In Progress" the Health bubble will turn yellow, etc. So far I have: IF(Status1 = "Not Started", "Gray", " "). I want it to change color for each…
-
Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…
-
Pre-populate a form
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change control log.
-
Hidden Phases - functionality
My company is trying to log "client travel time" (aka not consulting time) for projects as a separate phase for any given client project. That said, travel time wouldn't be logged too often and we have a preference to not have is show up automatically on staff's timesheets. I'd rather allocate the bank of hours to any…
-
Can a column be formatted for HH:MM entries?
I need like to track working hours in sheets so it would be helpful to format the columns as an hh:mm entry, is this possible? Thanks
-
Can a range be specified with a beginning and no end?
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
-
Index Match or Index Collect with multiple criteria
I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row, {Scope of Work}, [Scope of Work]@row)) Solutions? 😁
-
Need Help with Formula, want all project summary sheet to record most recent step completed
Hi I have a summary sheet that contains all projects that my various PM are working on, the project summary sheet looks like this: Each project then has its own sheet for the PMs to keep track of what steps have been completed for the project, looks like this: On the summary sheet in the "most recent step completed" column…
-
Giving an output based on text from multiple selection dropdown
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date…
-
Gantt View has come to WorkApps!
Hi Community, We have to admit, not having Gantt view in WorkApps kind of limited the scope of its project management functionality. Fortunately, we’ve gone ahead and taken care of that. Our latest release enables WorkApps to support Gantt view in the sheets experience! App users can now build pages using this view and end…