-
SUMIFS Formula for Rows Assigned to Multiple Contacts
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now that I have lines with multiple contacts assigned to them it will not recognize even the one employee's name anymore. I…
-
Trying to fix the start date of a subtask with no dependency
I trying hard code the start of a sub-task (4th level indent). When I try the start dates always comes back to the start date of the task of the previous indent. I would like to have my sub-task with no dependency to start much later (hard code the start date). Any suggestions? Thanks
-
IF formula to Assigned To
I am having trouble trying to figure out the formula based on the example: If the ISSUE TYPE is PTO, then assign it to XXXX. I have one column labeled "Issue Type" with a dropdown selection, and the other column labeled "Assigned To". Please help!
-
Array formulas
Hi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to perform: - I want smart sheet to show me in a column date, the first date, closest that…
-
Days Lapsed/Column Formula
How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it states it's not quite right to convert. Any suggestions?
-
Lookup To Return Multiple Results
Hi - I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to one cell in the other sheet. It seems like some combination of COLLECT, JOIN, etc.…
-
How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet!…
-
I will send you $100 USD if you can help me solve this
Hi there, If you can help me solve this, I will send you $100 USD via Paypal. My company generates leads for car dealerships across Canada. We will be using Smartsheet for our dealer partners to manage the leads we assign them. Each dealership will have their own sheet which their sales people will have access to (as well…
-
If function for children rows
Hi all, I don't know how to build a formula for the following: I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row to show ''Fail''. The children rows refer to the children rows of the parent cell.…
-
Getting Started
Does anyone know how to contact Smartsheet directly, I am on a trial version, I have sent numerous email requests, customer support forms etc. with no response. Is this normally how smart sheet runs? Should I look for different providers to support my project management Thanks Ben