-
Structured content in a cell
I has a sheet that uses RYG for status. If status is Red, I want my users to fill in a "FIX IT" column. Who is responsible When it will be fixed What will be done to fix it .... I would like to force this format. Can I tie a cell to a webform? Does anyone have a suggestion on how to collect this data?
-
date formulas
i'm looking for a way to add due dates. for example, i need the concept review 1 to be about 12 business days after after kick off the concept review to be about 4 business days after concept review 1 concepts to product marketing to be 2 business days after the concept review so on and so forth. but i'm getting all kinds…
-
Problem adding countifs
I'm trying to count projects that have either a four or five priority and this formula works: =SUM(COUNTIF({PLT Project Roadmap Range 17}, "Four"), COUNTIF({PLT Project Roadmap Range 17}, "Five")) I want to count projects with either a four or five priority that start either today or in the past and this formula doesn't…
-
multiple projects w/ multiple dates
i am trying to figure out the best way to put several projects with multiple due dates in the grid view. for example one project would have all the below due dates, and then we have several projects that we would like to see in the calendar view : project: Week 44 mailer Creative Concept Kick Off Concept Review 1 Concept…
-
Cell Formating
I would like to be able to format individual cells - what is the easiest way to do that? For Example - I have months listed with the forecast for that month and I want the cell font to be red if the forecast goal was not met. However, further down the column - the forecast goal might be higher.
-
Summary of lacking features
After running a project with multiple sub-projects since june last year, project is preparing/renovation of a eight-floor building for 1300 workers including construction, painting, electrical, lighting, IT, AV, the top three features I have been missing are (no ranking between them): 1. Baseline functionality 2. Ability…
-
Duplicate a workspace?
Is it possible to duplicate a workspace without automatic transfer of permission rights? Best, Wolfgang
-
=TODAY()
My 'TODAY' formula doesn't seem to be working...?! I've tried =TODAY(), =TODAY(-7) and other permutations but nothing works...?
-
Card View Restrictions
I have a user with Admin privileges, who is unable to see the 'View by Assigned to' dropdown from Card view. They also do not have the Card View Settings tool (gear) near the upper right corner, to be able to turn this on. From my account, I can do all of this on the same sheet, but he can not. What am I missing for him to…
-
errors
hello i am trying to use the COUNTIF function, where the range & criterion are the results of a VLOOKUP from another sheet. When the VLOOKUP doesn't find what it is looking for, it returns a #NO MATCH Error and this in turn gives a #NO MATCH error in my COUNTIF. On the VLOOKUP it is looking up an activity against a range…
