-
Automate High formula
Hi, I am trying to automate a trigger that looks at a WBS and if it has a High Status in the form of a ! mark, that it in turn auto triggers the some status in the top WBS name line. See attached screenshot. Thanks Cathy
-
display multiple columns in calendar view
Is there a way to display multiple date columns in calendar view? For example I have three delivery driver schedules in three different columns. I would like to display all three in one calendar view. How do i do this?
-
Split Screen for scrolling on Reports used in Dashboards
It would be helpful if you could scroll through the Gantt view of a report, separately from the Task view, when looking at a report that is embedded within a Dashboard. Today, there is only a single horizontal scrollbar and you can quickly lose sight of the associated tasks as you scroll to the right to see everything in…
-
Kanban Board by Team Member
We're using the card view for a company Kanban board. However, we also want each team member to have a personal Kanban board that just tracks the projects they're assigned to. Right now we're linking cells to a separate sheet for each person which is time consuming and needs to be manually updated every time a new card is…
-
IF Formula Help
I'm terrible with formulas! What would my formula look like to do the following: I have a listing of open action items, each with an attached target due date. I need the RYG overall project status balls to update automatically. Green if no action items are past due, according to the target date column. Yellow if one action…
-
Count Cells by Color
how do I count cells of a specif color in a row? Countif does not seem to do this as it does in Excel.
-
COUNTIF USING OR
How do I add an OR to the expression and logic: ="Resource: " + COUNTIF(CHILDREN(Status1:Status17), "Terminal Updated") + " of " + COUNT(CHILDREN(Status1:Status17)) I want to add both Terminal Updated and Terminal Replacement to the count. Any help greatly appreciated!
-
Month/Year to text
I am trying to extract the month and year out of a date column and join them to create a unique key. For example the value in the date column is 8/18/2017 I need a formula to return 82017 I can extract the month and the year without a problem, but when I try to combine them I get the sum of 8 and 2017.
-
[SmartSheet-Jira] Few basic workflow queries
Hey Guys, I started to use the JIRA connector for Smartsheet and run into some basic issues while creating the workflow. Idea here is I want to create the Jira tickets (Epic, Story, Sub-tasks, Bugs) from Smartsheet but need 2-way sync to keep updated everything on both the places. Query 1: during the workflow setup, I…
-
Cross referencing two Sheets
Hi All I am currently using a web form to collect data for a staff onboard systems which is working great, however, I need a way to cross-reference the data coming in from the form to a list of people I am expecting. until the vlookup feature arrive later this year any ideas on how to do this would be greatly appreciated…