-
SUMIFS Statement under Parent Item
I need to Sum the "Total" column cells IF: 1) Column Department Allocation Code = "49 CONTINUOUS IMPROVEMENT: Formula: =SUMIFS(Total:Total, Department Allocation Code:Department Allocation Code, ="49 CONTINUOUS IMPROVEMENT", Item:Item, =PARENT(Item1)) *Not working <img alt="" data-entity-type="" data-entity-uuid=""…
-
Form help - one field per row??
Is there no way for multiple small fields to appear on the same line? I'm wracking my head for what feels like a simple issue... Building an entry form and want a section to look something like (ease of use). Field A [_____________________] Field B Field C [________] [_______] -instead of- Field A [_____________________]…
-
Smartsheet export to excel corruption error
My team has been exporting a Smartsheet to Excel for over a year now then 5/30 we started getting a corrpuption error on our export to Excel (see attached Corruption1 & 2 Attachments). Trying to firgure out why this is happening now. I submitted a help ticket to Smartsheets however they miss read and assumed i was trying…
-
Parent Date Roll ups - Possible for two sets of dates?
I have a head scratcher here, thanks in advance for any help that anyone may have. My scenario is this, I have project plans that have two sets of dates, one is estimated dates and the other is the actual dates on the project tasks. In my project settings the estimated dates are linked to the dependencies. When I enter in…
-
Sheet scrolling with mouse issue
Hi, I am unable to sheet scroll using my mouse. Pulling the side tag works but not with mouse since today. Any reason for this? Rgds Ian
-
Coverpage for Tempaltes
has anyone come up with a creative way to combine a template with a cover letter? So example - we use smartsheet to gather requirements, we want to deliver those requirements to our customer at the end of the project in a polished package. Right now, we use the export to PDF, and add a few notes in the provided comments…
-
How to tell if Multiple Invoices have all been processed
I've created a sheet that we use to track our projects. For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a…
-
Error while uploading attachments
When i try to upload files to the smart sheet , any mail attachments or documents. I'm getting an error message and it doesn't allow me to upload the attachment.I have attached the screenshot of the error message. please help me with the same.
-
Automation / Update Request
Is it possible to set up an Automation / Workflow which will send a weekly reminder of any Update Requests that haven't been completed?
-
SUMIFS of a value that falls between a rolling date range
Good Morning, I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns: Job Type Planned Start JSH *job site hours* What I need is to calculate the sum of total JSH if the job falls…