-
How to Calculate Age from a Specific Date & Average Results
I am trying to average the age of multiple events as of specific dates (end of each month). Currently I have "Age" calculated from "Today()" in a column in another sheet. I would like to instead calculate the Age from "Date of Notification" to "End Date", and would like to avoid using a helper column to do so. I do not…
-
Merged: IFS Formula
This discussion has been merged.
-
Calaulate activity health based on % complete and Planned Finish date
In my sheet I have a column "% Complete" and "Planned FInish". Is it possible to create a formula which can highlight the row color in red, blue or green or yellow if % complete is less then 100% and planned finish is over a certain date (example 10 Dec 2024). I am new at smartsheet, need help from our community.
-
Counting quantities from another sheet that correspond with a reference on original sheet
Hi folks Really need siome guidance. I've tried the AI tool, but not getting anywhere. We are carrying out a network audit at multiple sites. I need to be able to display the SUM from another sheet when it meets the critera from current sheet: For example, I want to bable to display a summary of additiopnal switches needed…
-
Lookup the text of a predecessor by starting with the predecessor #?
Here is what I'm looking to do… If I flag a task as being late, I want to look at its predecessors to find the blockage. What is the easiest way to do that? I'm sure that I will need row numbers in this solution. Let's say I have that covered (I don't). Once I have that ready. I can look at the predecessor #, go to the…
-
How to extract just the month name from a date
Hi all, I'm trying to extract month name from the date column. It has been giving me an error. Any input will be highly appreciated.
-
Equipment inventory log
I am trying to create a workspace with multiple spreadsheets that will transfer rows back and forth from one to the other automatically. I have a sheet for inventory, one when the equipment is assigned to someone, and another to archive any movement. I have a form that they fill out when assigning the equipment out which…
-
Cross sheet refrence formulas on a metric sheet keep showing errors until the sheet is opened
I have 5 large sheets (10,000 rows, 45 columns) mostly populated by DataTable that I'm collecting metrics from on separate metric sheets (1 DT sheet → 1 metric sheet). The metric sheets collect the metrics via cross-sheet references. Some of the formulas "break" (breaking the dashboard visuals) but quickly fix themselves…
-
Pull info from another sheet based on 2 criteria
I'm trying to pull in hours to what I'll call Sheet 1 from Sheet 2. I have flexibility in the way I set up Sheet 2, but I need Sheet 2 to be able to have various employees use the same project number. This would be one option for Sheet 2: In sheet 1, I will have the project number listed in a column, but will only have the…
-
Find cells matching a criteria and return combined results
Hi, New to Smartsheet and hitting a roadblock in one of my formulas. I have two sheets: Projects and Resources. On the Projects sheet I collect resource groups that will work on a project. Each project in a row might have either single or multiple resource groups. On the Resources sheet I have resource group names…
