-
Auto-increment a new form entry if it matches an existing name
My team is using Smartsheet to track interactions with our customers on Facebook. To keep a record of the interactions, we're using a form to populate a sheet with the data (time, date, sentiment, that sort of thing). I'd like to find a way to automate one of the questions in the form - how many times we've interacted with…
-
Automating text based on information in other column
Is there a way to format something like this: If column A is True than column B says blank? The reason I ask is that I have a report with site in one column and the next column should have id. It would be much easier for the id to popluate based on the site in the first column.
-
Formula to calculate the next Friday after today
I have the formula below in Excel that calculates the next friday from today's date; so that any time the sheet is opened before a friday it will automatically insert the date for the coming friday, and when that date has passed and the sheet is re opened it will automatically insert the next fridays date in the week…
-
Date Driven row roll off
We keep a list of Completed tasks. Based on the date in the Work_Ended column, I would like to autmomatically move rows > 90 days old onto another sheet, which we'll call Completed Archive. Is there any way to automate this process? Thank you!
-
Extract top risks from risk log for highlight reporting
Hi there I'm running a risk and issues log and need to pull out my top 5 risks and issues into a monthly highlight report. These are based on the original risk score and the score post mitigation(s). Within my highlight report I have a number of cell links which pull through parts of the project plan but because the risks…
-
Auto-fill formulas for children rows
I click on the parent row that is below the children and insert a new row. This comes up as a child row for the above parent but the formulas that those children have do not autofill to the new row. Can this be changed?
-
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A
Given two columns A&B, what formula would I use to pull a value from B that corresponds to the MAX(A)?
-
Average Children Rows with RYG
Hi all. I'm attempting to calculate an average for RYG balls in the parent row. I have gotten to the point of calculating all of my colors, but I'm not sure how to get the average. Here is my calculation thus far: =AVG(COUNTIF(CHILDREN(), "Green") + COUNTIF(CHILDREN(), "Yellow") * 2 + COUNTIF(CHILDREN(), "Red") * 3) This…
-
Formula Separator
I'm attempting to create Red Yellow Green balls based on 2 formulas in one row. I have one formula for early, late, on time, and another for whether the phase has been completed. Basically I want to show green if the row is early or on time and/or if it is completed/cancelled, but red if it is late and/or stalled or not…
-
Formulas in Smartsheet
Im trying to get a formula to work in smartsheet. Can anyone help me out? =IF([Travel Type]1, "craftworker"), ".3", ".4") I want it to apply $0.30 to the cell if the travel type selected is craftworker.
