-
Unique codes
Hey all, I am trying to create a system that will check a unique code that is entered through a form and display if this code has been used already or not. I have a formula in the summary sheet that will asses if the code has been used or not: =VLOOKUP($Code$1, {Z Codes Trial Database Range 1}, 3, 0) The problem is that I…
-
Formula - convert a name to e-mail address
Hi all, I am looking to convert a name to a e-mail address using a formula. This is the example: convert 'Andreas Johnson' to 'Andreas.Johnson@company.net'
-
% Complete Formatting in JOIN Formula
I am trying to Join various data points into one cell and when I join the % complete, it changes to decimal format. I've tried adding Value in from of the %complete, but get the same result. Can someone let me know if there is something I should add to my join formula to convert the decimal to percentage? Thank you Tiffany
-
Merged: formula in a report view
This discussion has been merged.
-
COUNTIF using OR
Hi, I'm trying to count how many check boxes (out of a possible 4) are checked on a row (basically, countif w OR x OR y OR z is checked). I've tried many variations of the following formula: =COUNTIFS(OR[PNS]@row = "1", [EIP]@row = "1")) Thank you!
-
Calculate number of days and years from start date
I need to see how long staff have been with us, their tenure. I need this for any given dates, meaning "today". I have the start date, how do I get the days from that in years and days? Example: Start date is 06/01/2020, today is 08/23/2023 so the Tenure should be 3 years, 2 months, 22 days. I would take 3.2
-
I need help creating nested formulas to pull data from multiple sheets.
Hi Smartsheet Community, I am working on creating a training matrix based our training documentation. Here is the set up of the training matrix: peoples names as columns and the trainable documents in the rows. I added the helper row because I couldn't figure out how to use the columns in a formula. This is the separate…
-
Assist with Date Helper Column Formula
Hi, I have a sheet with a Date helper column that is being generated from a Primary column with a MM/DD/YYYY text format. I can get the helper column (set as a date type) to show up as MM/DD/YY without issue using this column formula: =DATE(VALUE(20 + RIGHT(Primary@row, 2)), VALUE(LEFT(Primary@row, 2)),…
-
Date and Product formulas
I'm referencing a sheet and I need to see how many product a have an end date between 30 - 60 days. Thank you!
-
The $ Formula
A consultant I worked with was tasked with building a graph showing our portfolio growth over time. The graph needed to be a 12-month trailing horizontal axis which uses the (already recorded) dates for when any new project is triggered for provisioning. On the vertical axis, we wanted to track the sum of the project sizes…