-
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!
-
User Unsubscribed from Automated Workflow
Hi I have set up automation on a sheet to email spacific people when lines are added, some of them have complained they are not recieving the emails and when i looked into the Activity Log it shows User Unsubscribed from Automated Workflow. When I checked with the user they dont recall doing so and were actually Out of…
-
Formula to return 'TBA' if cell contains text 'TBA'
Hi, I'm currently using this formula which works: =IF([\[H\] Variance (%)]@row < 0, "Under Budget", IF([\[H\] Variance (%)]@row = 0, "On Budget", IF(AND([\[H\] Variance (%)]@row > 0, [\[H\] Variance (%)]@row < 0.15), "Moderate Budget Overrun", IF([\[H\] Variance (%)]@row > 0.15, "Significant Budget Overrun")))) However, I…
-
Can we bulk export sheets to PDF that are part of a report?
This question stems from a previous topic. Given a report that pulls from 10 sheets (updated by different PM), can I bulk export all sheets to PDF so I can drop them in a Box folder for archiving with a weekly report summary?
-
Newbie Question: Want to Count "Product Name" but only if its date is in the future
Hello! I am very new to Smartsheets and I am trying to get the best use out of it. But, I am little stumped. I have a COUNTIF formula to count how many times a product name is mentioned in the sheet and then I used conditional formatting to highlight it if there is more than one time the product is mentioned.…
