-
Bug in the system? formula from system column (created date)
I have created a workflow automation in the following sheet that is based on the hour of when this is created - this is taken from Created date column (system column) Column is called “Hour of creation” The problem is, every time anyone makes any change in the sheet, the hour of creation gets changed. This happens for all…
-
Sheet Summary Formula's and Report
I have 26 individual sheets that I want to roll up into a report. Each sheet collects data based on partner name, term(single drop down)and meeting type(single drop down). I have used a separate metrics sheet in past projects, but wanted to use Summary. I have the following Summary Field Properties created on the sheet:…
-
Auto-populating Job Numbers
I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below: If we…
-
How to make the number in my string + formula display as a percent?
I am having an issue where i have created a string plus a formula (="Percentage Complete " + COUNTIFS(Complete2:Complete11, =1) / 10 ) is there any way i can get the number that is being counted in my formula to read as a percent? i tried clicking the percent symbol while having the cell selected but since the string is…
-
Adding Unique Cost of Items in a sheet of form results
G'Day All, I've tried to search, but come up empty handed! I'm building a stock control system that suits our business, and trying to work out the cost of an item (Items are in Columns) adding each time it was bought (Buy price may vary) Each row will be a form response, adding a quantity of the item bought, and the value…
-
IF Y is blank, and X is not, take Date of X and add 90
i know this is not correct.. but. can someone help me fill in the missing pieces. =IF(ISBLANK([Renewal End Date]@row, [Agreement End Date]7, +90)) my goal is to have the Next Review column produce a date that is 90 days from either the renewal end date (if there is one) or the agreement end date Thank you in advance!🙏
-
Statistical Trending in Smartsheet
Hi All, We previously used minitab to trend control data for laboratory equipment, and while I know Smartsheet wouldn't be able to replicate that level of statistical processing, I want to leverage automations to make this type of data tracking more meaningful in Smartsheet. What I am trying to do is to call out data (by…
-
Bug in VLOOKUP on a RANKEQ formula?
Hello, I'm using VLOOKUP to find rank order from another sheet which uses RANKEQ. Periodically (pretty frequently, like every 24-48hr) the VLOOKUP will return an error. Referencing the RANKEQ on the other sheet everything is in order, the VLOOKUP just fails to find the specified rank order (i.e., 1, 2, etc.). What is…
-
If Formula Help
Hello all, I created a requisition form with collumns to allocate products to 3 different locations and 7 departments inside of 1 of those 3 locations. Each location and department has a corresponding code. Our main location, "EHT" is 1-7 and the other two locations are 8 & 9. The formula I'm using to allocate products by…
-
Percent of checked boxes in summary fields
Hello Smartsheet world, I have two checkbox columns and I need a formula in the summary fields that calculates the percent of students that have both checkbox columns of "Fall 2020" and "Spring 2021" checked out of the total number of students that have checked boxes in "Fall 2020" plus the total number of students that…
