-
SUMIF on Cross Sheets
Hello, I've been trying to create a roll-up based on "Region" from another sheet and I either get "0" or invalid argument. On inventory sheet I have multiple columns with Budget, Actuals, ect and would like to sumif based on Region. The formula below returns "0" =SUMIF({Inventory Range 1}, {Inventory Range 2} = "ProServ…
-
pdf and excel files into multiple sheets via Gantt?
Hi there, trying to make a production line more efficient and I need to attach a file to each order (each order is a separate row). We run off of multiple sheets, and have reports broken down to each department. For example: Main Sheet: Gantt Production - includes all orders (which are linked to multiple reports) Report:…
-
Server/Local sheets get out of sync, some permanently
Hi all, I am working with SS support but I thought I would reach out here as well According to T2 support ...If our server has not processed all data/ formulas before a save is made the sheet may show a different version than our server shows. In most cases the dirty save only lasts for the first 2 rounds of saves.... This…
-
Getting Status of Children to roll up to Parent Row
I have Parent tasks with Children tasks in a dropdown list column. The options for the children are: assigned, in progress, complete. would like to have the parent status display be blank if none of the children have a status selected (all are blank), display "Complete" only if all the children have a complete status,…
-
Resent Request for Approval
Is there a way to send a reminder to someone who received an automated request for approval? I have program chairs who are either not responding or are not responding in a timely manner, so the Approval Status remains "Requested". Right now, I reset the status so it triggers the automated request for approval again. It…
-
Inconsistent Horizontal Column Alignment
Is anyone else experiencing a problem where new records entered into a Worksheet sometimes aligns the text horizontally at the top of the row, and other times at the bottom, or center?? I can't find any consistency in some of the columns, even if I've set the entire row to align top, or align center, or align bottom. Any…
-
Which is better in this case = Nested IF statement or using two formulas related to other columns
Hi, In the spirit of efficiency of memory usage, I want to figure out which methodology would be better: In either case, A/B are columns used to toggle several sheet functions as they relate to the heirarchy level the row is. * Use a nested IF statement: =IF(A@row = 0, SUM(CHILDREN()), IF(B@row=0, INDEX({REF Share},…
-
Routine reminder
Hello, I am trying to set up a routine reminder to notify staff to submit a report. I would additionally like to have it notify other staff to follow up to collect reports once the due date passes. I set these up as two different workflows but if I can combine let me know. I am also trying to find a way to not have to…
-
Sign-in Sheet using Smartsheet & Forms
I have built a sign-in sheet using forms (yay) but am now wondering if there's a way to do the following: We occasionally collect some attendee data that I'd love to have pre-populated so that people can sign in and add in the rest of their information and also sign there. Is there a good way to do this in Smartsheet?…
-
Surveying Project - How to setup the structure of Smartsheets
I need to send out Architectural Survey team out to the field to survey the existing conditions of a restaurant. Information gathered is Electrical Information (Panel Size, # of Breakers), Equipment (Make Model and serial#), Condition of Walls,etc. I'd like to send them with a Ipad with a Smartsheet form, but I'm…