Is there a way to insert a timestamp into smartsheet when a specific field has updated? I would create a column that it can be stored in I just don't want to have to have the team manually update it. …
Hi I am trying to count the number of items that are for a particular month and year. eg: I would like to count the number of items submitted for the month of Jan 2018 the column I am wanting to pull …
Hi, I am looking for a formula that will allow me to limit the options seen in a drop down based of what is selected from another drop down. For example, Column A would is a State Drop Down and Column…
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying …
Hi the community! I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";" When I use the "@row" reference in a form…
I'm trying to get a formula that will do the following: Give me a RYG result in a column, by looking at whether a project item has gotten close to the due date, compared to what the status is on that …
Good afternoon, Wondering if anybody knows how to enter the following formula that we use in Excel: =NORMSINV(1-(total defects / total opportunities))+1.5 into Smartsheet, we use it to calculate Sigma…
I have users inputting data using a form. The data comes into my sheet at the top. At the bottom of my sheet I have a cell that is summing the numbers in a column called "Sales Amount". Each time a ne…
Should be simple, but I'm struggling. Two columns Text Column that contains some text. Checkbox Column I would like a folmula for the checkbox column to check the text column for some text. If the tex…
Good Morning. I am attempting to create a forumula which references another sheet; however, I continue to receive error messages or it doesn't calculate correctly. Below is the outline of what I am lo…