-
Rotate Text?
Can titles of columns be rotated so more can be squeezed into view?
-
IF THEN formulas for status balls
I am trying to use an IF THEN formula to show status balls. I have a "due date" column and a completion column. If the date in the completion column is more than 7 days later than the date in the due date column, I'd like the status ball to be red. If the date in the completion column is within 7 days of or before the date…
-
Tags (possible feature request)
Hi, is there any way to tag rows? I can use a dropdown list, but that only allows for one "tag" per row. I could also use a comma-seperated list, but without autocomplete and/or tag-management it's a very error-prone approach. All feedback is much appreciated!
-
Resource Forecasting
Here's what I want to be able to do for resource management. Is there a workaround to accomplish this? * Assign individual resources (they are not licensed users) to a team\group. Assigning tasks to multiple individuals does not work for me. * Each individual has default work hours. E.g. 8 hrs. It can be modified if needed…
-
Gantt View - Settings requests
Hi, I'm trying to create a dynamic 'To-Do' list (for want of a better phrase), that automatically steps the jobs - i.e. only start task 2 when task 1 is expected to complete. I want to make this as automated as possible, and I understand that dependancy columns do not accept formulas, but wanted to know if there was…
-
Link to another sheet and add additional days
Hi there, I am trying to link to a master schedule but adding some additional days to define my drop dates. Please help. Thanks.
-
How to create a future date based on a date in another column?
Hi, I am looking to create a formula in a column that automatically calculates the date of 12 weeks from the date of deposit column. Can someone please help with the formula? I keep getting errors. Specifically I would like the "estimated completion date" column to be the "date of deposit" column plus 84 days. Thanks! Keren
-
Linking sheets through dropdown box
Is it possible to create a dropdown box which draws it's items from the primary column of another sheet? I am putting together a system for managing the data related to my staff members including workplans, professional development and reporting. On each sheet I would like to be able to ask the staff member to choose their…
-
Smartsheet Consultants Needed
Hi community, Our organization just purchased Smartsheet Enterprise License - and is looking for consultants to build the solutions which require API integration. We have contacted with Smartsheet internal team and they quoted us $12,900 + extra travel expense, just for 2 days on-site "discovery and planning workshop",…
-
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…