-
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…
-
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…
-
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…
-
How can I get this formula to work
Hi, I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to…
-
Count and Lookup - based
Experts, I need to count the values of each column excluding Today Value. Rest of the Yesterday and Blank values of respective columns like #New Hires, and drop the values in the 2 Yesterday Metrics. It is pretty easy to do a vlookup for Today, but if I need to cumulate the Yesterday and Previous day values. How do i do…
-
Use dependencies to set start and end dates independently
how can i use dependencies to help set both a tasks start AND end date independently (not using duration)? As an example, i would like row 3 start date to be row 2 start + 5 (I can get that by setting predecessor = 2SS+5), but I want row 3 end date to autopopulate with row 4 start date.
-
Count if Formula to retrieve multiple criteria
Hello Experts, I am looking for a formula to count all of the New Hires from Yesterday/Today column using Previous Days and Yesterday values.
-
Batch Sheet Creation from Template
Problem: Current Limitations Manual Repetition: Provisioning a large project (e.g., 50+ distinct team sheets) currently requires manually executing the "Use Template" or "Duplicate Sheet" workflow 50 separate times. Time-Consuming Setup: There is no native bulk-action to instantiate multiple files at once, creating a…
-
VLOOKUP to Gather Monthly Adoption Number based on Country
I am trying to find a way to create a metrics based on our monthly adoption numbers, this is the sheet that im trying to take the data from and then enter into the applicable fields in my metrics I want to take if its Global, and if the month is ex: January, take the Online Adoption Rate total and copy it into my metrics…