-
Parent Row Roll up using a specific text value
Community: I am piggy-backing off Nathan Skyers' request from November 24, 2016 1:13 pm, regarding Parent Row Roll up, as I need a very similar formula. Any help will be appreciated. Thank you, Sandy Is it possible to have a text value show in a parent row whether all statuses match my criteria OR if even one status…
-
Is it possible to remove slashes in date and convert to number
a bit like this https://www.mrexcel.com/forum/excel-questions/523890-how-remove-slashes-date-convert-number.html
-
External Collaboration & Communication (Outside Company Contacts)
If I send a written proposal through Smartsheet, as an attachment to an Update Request, and the client responds, I know that I will have an email verification, showing me any changes to the worksheet. However, at a future date, if our client wishes to send an approval verification through Smartsheet, they cannot use the…
-
Activity weightage in %
Hi, I want to know whether smartsheet has facility to show activity weightage in %. For ex. I have one main task and 4 sub task. I want provision to assign weghtage to each subtask. Same should be rolled back to main task. Share the information if available. sandip
-
Formula: Look Up for two value
Hi, This one is pretty easy in Excel but I have no idea how to do that in SmartSheet. I have 3 columns in SS: Fruit, Brand and Price [Fruit]1 is Apple , [Brand]1 is ABC Ltd. [Price]1 is 100 [Fruit]2 is Apple , [Brand]1 is XYZ Ltd. [Price]1 is 50 [Fruit]3 is Pear, [Brand]1 is ABC Ltd. [Price]1 is 100 I want to have formula…
-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Date Columns - Formats
I fear that I will be out-of-luck here, but we'll give it a try. We're using SmartSheet to layout a timetable for a tricky real estate development project...fairly straightforward stuff. However our cap-x committee has asked to see the chart laid out with days (1,2,3...600,601, etc.) instead of calendar headings. I've…
-
Identifying children for a specific parent automatically
Hello Community Team, I'm working on automating a % Effort column for my project plan. I need to avg the % effort at the parent level of its associated children. I want to do this automatically without having to identify the children under the parent. I can use =avg(children()) but I will need to specify the children cells…
-
Group rows together for the same Report#
Is there are way to group rows together if the same report # shows under the Report# column multiple times? Lets say the Department of Transportation stop one of our vehicles for a truck inspection and they find a number of violations. A report # is generated on the report they send our company and it may have 3 to 4…
-
Resource Allocation in Parent Rows
Does Smartsheet allow resource loading parent rows? I am trying to assign parent rows to staff and allocate percentage on the parent row, but it does not allow allocation entry on the parent row. I do have resources enabled on the sheet. I do not want the parent row to sum the allocation percentage of the child rows.…