-
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…
-
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 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…
-
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…
-
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…
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
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!
-
Concatenate with a Date
I am sure the answer to this is simple, but I just cannot get it. Here is my current formula: =[TO - Project]@row + " - " + [Deliverable Number]@row + " - " + OY@row + " - " + [Date Submitted]@row Now the Date Submitted field displays as MM/DD/YY, however I need it to display as MM-DD-YY I have tried a few things, but all…
-
Last recorded date by User - 2 month reminder
Hi All, I want to create a simply usage log for equipment (CMM), we want users to keep skills current, so they record when they log-in. We then want automated reminders / notifications if the user hasn't used the equipment for 2 months ('Related Email Address' field). The puzzle for me is that there will be multiple…