-
Pulling Parent/Ancestor info depending on row hierarchy
I'm trying to have a column (Dept Helper) auto fill based on one Ancestor cell in another column (Department). I have a helper column (APC) keeping track of the hierarchy already (Ancestor = 0-Anc, Parent=1-Par, Child=2-Chi). I only want the Dept Helper to fill-in rows that are not the header row (Ancestor). Here is the…
-
Link Columns to another sheet dependent on answer to question
For all exams listed on our Assessment sheet , if no incidents during the exam occur, is there a way to streamline by cross-referencing the Assessment sheet to populate specific columns in the incident report sheet instead of completing a separate report? I'd like a user to go into the assessment sheet, scroll to the…
-
How to average the time between various dates if conditions are met
I'm building a spreadsheet with monthly metrics and having issues creating a formula. There will be a separate smartsheet with individual events (1 row per event). Each event has ~3 review cycles. Each review cycle includes the date the draft was provided & the date the draft returned. Formula I'm trying to build: If the…
-
How do I create an automation that ignores certain calendar days?
I created an automation in which I inserted 3 columns with dates in this way: Column 1: date A Column 2: date A +3 days Column 3: date A +5 days The problem: I would like the automation to ignore weekends and public holidays (of the Italian calendar). But I don't know how to do it, does anyone have a solution? 😊
-
Conditional formatting change status with colors
I want to change the status and the cell will change of color (red, green, etc) depending on the status. The sheet that I am working on doesn't have that possibility in the column settings.? see the image below. can you help me with that?
-
Automation and Scheduled Emails - Only on the hour?
The current default design in Smartsheet is that automated workflows and scheduled email notifications can only be sent on the hour...Let's say you have a weekly 8am meeting, but you want to send an automatic weekly email before the meeting at 7:45...well right now there is no option to do this. You can send it at 7am or…
-
Project Administrator (aka SmartSheet guru) position with CSU CEMML
Colorado State University's Center for Environmental Management of Military Lands (CSU CEMML) is hiring a Project Administrator to support a growing team working on multiple, simultaneous cultural and natural resources projects. These projects are often multi-year and involve complex schedules with numerous deadlines and…
-
Workflow for After Hours Tickets
Hi all, I currently manage our support tickets smartsheet and live on east coast. I have a team member who lives on West Coast and I want to create a workflow to have any tickets submitted between the hours of 5pm EST and 8PM EST sent to him with a notification. Currently, I am capturing the date/time ticket is submitted…
-
How do I report on the Intake Submission Date field from the Project Intake Sheet?
Hi, I'm using the PMO template. The "Intake Submission Date" column is system generated in the "Project Intake Sheet". Is there a way to pull this column into a report? When I create a report using the Project Intake Sheet, the Intake Submission Date does not show up as a field that I can select. Project Intake Sheet and…
-
I think I need an index match formula as source sheet is unsorted
Hi, people smarter than me. I have been trying for days and days to get a formula to work. The source data is not sorted; it is populated by form data. The vloopup formula only duplicated the same result from the first row over again. =IF(VLOOKUP([Primary Column]@row, {2024 Circulation File Num to Support Level}, 1, false)…