-
Averageif function looking at a list criteria
I am trying to create an averagif formula that looks at a list of values in a cell. Currently if I do it the normal way it just returns back if this specific value is the only thing in the cell. But once there are multiple items in the cell it doesn't count that within its result. Both formulas return the same way per what…
-
Expand/Collapse rows
Expand / Collapse all is not an option on my primary nor any of my parent rows. Why?
-
Is it possible to develop a task list from multiple source sheets through automation?
We are creating new courses and content for our LMS and we want to use a project sheet to track all the tasks associated with developing the course and its respective content from beginning to end. We have a handful of different "Learning Object" types that each have their own repeated tasks or activities to develop and…
-
Cross Sheet Joining Automation
Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox that initiates a purchase request next to each item. My initial stab at this is when…
-
Can you append sheets in Smartsheet like you can power query in excel/power bi
Hi I want to append/consolidate sheets in smartsheet in a master file or separate sheet all the sheets are the same but for different locations im using forms to collate the info because the forms are site specific I want to combine the two sheets below as example in a master sheet and at the same time the master will…
-
Automatic Linear Percentage Complete Formula
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
VLOOKUP with IF and IFERROR Formula
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull in Survey Status “Complete”, otherwise (IFERROR) "N/A". This is the new formula I…
-
Collaboration in Smartsheet (Saving)
Hello, I am just wondering what is the best way to work in collaboration on smartsheet. Currently when multiple users are working in the same sheet and one clicks save the other users data is lost! How do I prevent this from happening. What is the best way to guide the teams on how to work with each other effectively.…
-
Sheet populating at row 51
I recently created a sheet and form for patient safety surveys. When the form is completed, data is populated starting on row 51. What did I do wrong and how can I get it to populate starting at row 1?
-
How to "gray out" a completed row?
Hi All, Thanks for reading. I read in a different Smartsheet thread that if you filter out "complete" rows on Smartsheet, you can't sort them. How can you create a feature that grays out your whole row when checked? Thanks!
