-
Trying to calculate a countif and contains a "city"
Hi I have a sheet that is filled out by staff and another sheet that has a breakdown of % compete for each branch. The requirement is to calculate how many power users from Calgary have completed the checklist There are 10 members in a Calgary need to find the percent that have completed the power user training. Was trying…
-
Non-repeating email notification when value in sheet is reached.
Hi all, We have an automation set up to send an email for when a certain value in a cell reaches 50%, 75% and 100% of a predetermined value. For example, the automation will fire when the cell value is 10 of the predetermined value of 20 (50%). Our issue is that the notification fires off again every time the cell value…
-
Introducing the 2023 Core Product Certification Exam + Community Badges
Hello, We are excited to reintroduce badges on Community to celebrate your Smartsheet product expertise. When you become Core Product Certified, you’ll not only receive a badge on Credly that you can share on your LinkedIn page but you’ll also receive a Community badge that you can proudly showcase on your profile.…
-
Cell Contents deleted during edits
Hello Has anyone seen an issue where the contents of a cell are just wiped clean as you navigate from one cell to another by using the arrow keys or hitting enter? This appears to be a random effect and not browser based and appears to have started only recently. Did not do this before. Thanks
-
Using forms for ordering product
Afternoon, I'm working on an order for for our customers. Is there a way to have totals add up on the form? They receive free shipping for order over $2500, but I thought it would be easier for it to auto calculate instead of the customer doing it manually.
-
ampersand symbol in Smartsheet form emails
When collaborating and/or leveraging forms with email confirmation, if/when the title of the form contains the ampersand symbol, it errors when the email is received by the end user. An enhancement can be made to enable the product to be able to send emails from Smartsheet without a character error.
-
NetworkDays with IF functionality
Hi, I am trying to gather a sum total headcount for each day of the month based off another sheet that has a date range of each users visit. How do i capture the total headcount for each day a user is onsite? I have been using IF(NETWORKDAYS( START DATE, END DATE, = specific day) and get an incorrect argument error.…
-
Days of the week symbol in column
It would be cool if there was a column type that was a "days of the week" where it's basically seven dots with S-S and based on the days of the week for that row, either selected in that column or based on a calculation, it would give you a symbol for the days of the week that the row corresponds with. It feels easier to…
-
Automation Row Transfer - Not showing on the destination sheet
Hello, I set up an automation where when a certain field is fulfilled, it moves the entire row to another sheet. The automation moved the row off my sheet, however, it isn't showing up on the sheet where it's supposed to transfer onto.
-
Invalid Argument with COUNTIFS formula
I have a form created to capture checklist Yes/No items for safety observations. There are several questions that are grouped by type (i.e. General, Electric, etc.). I have figured out how to use the COUNTIF formula to count the "No" answers for each group of questions to establish where the risks are taking place:…