-
SUMIF vs. SUMIFS
I am looking to add the total hotel night stays from multiple labels in a single criteria column. This is my formula, but it results in "0" which is incorrect: =SUMIFS(NIGHTS10:NIGHTS38, AFFILIATION10:AFFILIATION38, "Researcher", AFFILIATION10:AFFILIATION38, "RAN", AFFILIATION10:AFFILIATION38, "ECD awardee") NIGHTS:NIGHTS…
-
Project Cost Calculator Smartsheet
I am looking for a template in smartsheet that I can use to build costs for projects and training courses we conduct. I noticed that on the smartsheet website advertisement it says that smartsheet has the solution. My goal is to program some of our costs to do business with certain rates and then send forms to the Program…
-
Can Barcode Scan return Sheet Data and Auto Complete Form?
Hi! Help!! I'm working on a Sheet to help with our Kanban System. As an employee takes a part from the Kanban Bin, we would them like to scan a QR code of the part taken via a form and the barcode reader on his smart phone, we have set up a test sheet using a lookup table of all parts (on a separate sheet "inventory") then…
-
Only print field in form when value is not zero
I have multiple columns in my smartsheet that may or may not get filled in ($), depending on the specifics of the permit. I do not want the fields that remain $0 to print or show up on form. Only fields that get filled in with a dollar amount need to show up on printed form. Can't seem to figure this out.
-
Date validation
Hi... I tried search on validation of Dates, especially while selecting while selecting dates from form. I need to restrict use of past dates and user should be able to select dates which is today or ahead of today. Please suggest.
-
Published Reports Filtering
I have a customer that is using a published report and they want to be able to filter directly in the published version. Since the source data sheet has the information for all our other customers as well, I do not want to share any sort access to that files. Any help/advice would be great. Thank you!
-
SPI
Is there a way to easily track SPI within Smartsheet?
-
Conditional Formatting for two end dates
Just to be clear I only have one end date in my sheet. The sheet has a conditional format set up to flag "At Risk" tasks when the end date has already passed. Here's the current formula: IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0) I want to add another condition to flag the task when it is within 5 days…
-
Portfolio Report Pie Chart
I'm trying to develop a pie graph based on a sheet of projects with R/Y/G reporting. Basic pie graph with % of total by status indicator. The issue I'm getting is that SmartSheet requires integers for graphs, I think. If anyone has a workaround please let me know. I could assign an integer based on R/Y/G status, but then…
-
Issue w/ Rules - Being unsubscribed
Is anyone having issues with rules and being unsubscribed? With the smartsheet (server side) issues over the past few weeks, i've had a ton of sheets to re-do all the rules on because there is no global option for that. Anyhow... This week we are experiencing issues w/ the rules unsubscribing users out of nowhere. As you…
