-
Duration based on time - formula question
I was able to create a Smartsheet column with time included with the date (Thank you @Paul Newcome & @Akblevins ). I want to add another column that just shows the time - I used the AI Smartsheet feature to create a formula but receive an error message. Any ideas on how to correct? TIA!
-
Help with a formula or formuals
I have 3 columns: Vic By plate number and model, Date Driven(Date Field), and mileage. I am trying to fina a formula or formuals to allow me to see the difference in milage since the last time the plate number has driven. Bonus: In 1 month. Trying to find an easy way to see priority of which vehicle needs to be driven next…
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
Having trouble creating a multiplication formula
I used the AI chat to help create a formula to multiply PPU by STOCK and apply the sum to the entire INVENTORY VALUE $ column. =[PPU] * [STOCK] Why is the sum not populating in the "INVENTORY VALUE $" column? I have the properties set to American $… I think. The AI chat said there may be an issue with the sheet set up This…
-
Counting parent 'in progress' rows
Hi, I'm trying to write a formula to count the number of tasks In progress, where the row level is"0" or "0+" (which are parent rows). Here is my formula: =COUNTIFS({Level}, OR(@cell = "0", @cell ="0+"), {Status}, "In progress") Here's my sheet: I should be getting a total count of 5, but the formula is returning a count…
-
Help with a formula or formulas
I have 3 columns: Vic By plate number and model, Date Driven(Date Field), and mileage. I am trying to fina a formula or formuals to allow me to see the difference in milage since the last time the plate number has driven. Bonus: In 1 month. Trying to find an easy way to see priority of which vehicle needs to be driven next…
-
Combining Contact Cell Contents
I have three different columns on a sheet, each for different uses. But, I am creating a Dynamic View of that sheet and I want to make that Dynamic View available to contacts in each of those three columns. I tried to combine those columns into one "Dynamic View" column via a formula that would obviously change when…
-
Using a reference sheet to bring in reference dates (e.g., 6 months ago, last month, etc)
I thought it would be easiest to create a reference sheet to house dates so I'm not constantly creating timeframe stipulators in my sheets, especially now that I am trying to create portfolio level rollups. When I observe the switch over from Mar to April, it seems like in order for the reference sheet to show April 1, I…
-
Formula when using sheet hierarchy
I'm setting up a sheet to track team initiatives. The end goal is to be able to have reports that do the following: (a) one report that lists all initiatives; (b) individual team reports to show just their initiatives Note: The initiatives are the primary column/parent rows because some initiatives have subtasks/children…
-
Help with Formula Please
Hello! See screenshot below. I'm trying to auto-populate the 'Completed Date' using a formula, but I'm not sure if it's possible. WHEN the 'Jira Status' is 'Closed', I want to auto-populate the 'Completed Date' with the same date that the 'Jira Status' was moved to 'Closed'. Is there a formula for this by chance? TIA!