- Update Template
I would like to see an option to edit/update a template without using the template to create a sheet, editing the sheet, and saving as a new template. The current process creates additional templates that might have to be renamed and then removed. If we could edit the template itself, it would make the process much easier…
- Calculate % Complete at Child Level AND Parent Level in one formula
I want to use the following formula as a column formula but have the % complete roll up to the parent level. See formula and snapshot as it appears now. I want Q3 and July Promotions fields to reflect a percentage completion based on the children rows. I can't seem to make it work! % Complete formula: =IF(Status@row =…
- 计算每个值在一个多重电极5ld
I have a primary sheet where team members are dropped into a contact column if they're working on a project. So the Contact column for any given project row might have one contact or three contacts in it. Then we have a project status column. Example... (Project Name Column | Team Contact Column | Status) Project 1 | Kate…
- Conditional Formatting for Dashboard Metric Widgets
When using dashboard metric widgets, it would be helpful to be able to have conditional formatting features to compare performance to a KPI or otherwise enhance the metric display. Even if the data source document already has the conditional formatting existing, it will not transfer along with the data to the dashboard…
- Sort column containing dates in chronological order
· Problem: It is not possible to sort a column containing dates by chronological order · Use Case: list of annual leave for employees working on a project · Ideal Solution: Enable sort by: chronological order for a column containing dates
- Synchronise Team Member Availability between Resource Management and Smartsheet
I have team members with part time availability, as specified in their Resource Management profile. Smartsheet allows me to schedule tasks for the days they are not working - the sync to Resource Management then displays "100% allocated for 0 Days" - the 0 days is due to this being a non-workday for that team member.…
- Creating Column with fomula using Control Center returns UNPARSEABLE
Hello everyone! I am running into an issue when using Control Center to create new columns with formulas across my active projects. I have already tried the column with the formula in one of these sheets and everything works fine there. However, in testing and creating the columns using Control Center, it returns the…
- IF OR Statement Return False Value
Hi...I'm looking to close a simple IF OR statement and it seems I'm missing something. 2 values where if 1 or the other is less than 0 return "Red" if false "Green" and returning Green is just getting an error, here is what I have: =IF(OR(IDEA34 < 0, IDEA58 < 0, "Red", ("Green"))) #incorrect argument
- How do I return DISTINCT values from another sheet based on specific dates within that sheet?
Hello, I have a need to return a Distinct Item ID from another sheet based on a date range from another date column within that same external sheet. The formula below works; however, once I run out of Distinct item IDs that meet my date criteria it continues to return results that fall outside that date range. Current…
- How to pull avature application date from another sheet
Hello, I am stuck coming up with collecting avature application dates from another sheet. The full name is the column that I want to use from other sheet to pull the avature application date over. Below is the sheet where avature application date is:
