-
Formula Help Mapping
Hi, I have 2 columns on my smartsheet, A and B. A can have up to 30 values or so (example : open, not started, in progress, deployed etc) depending on the value of A, I need column B updated (example if A is "open or not started or to-do , B should be "not started" and if A is "in testing or dev or QA" then B should be "in…
-
Automation problem
Hello users I have a problem with notification mail (reminder) I have 2 dates. Planned and released. I would like to receive 1 mail (twice a week) with following information all task which has not been done but should be (delay ones) and all task that need to be done with next 14 days. Please find my form attached and let…
-
Created Formula but it is not performing as I thought
Hello, I have created a formula in smartsheet so when a date is met (availability date) the team has 30 days to update the date before it moves to another sheet to be archived. However the date (availability date) comes up and it moves that data, not allowing the 30 days. Did I write the formula incorrectly?
-
Formula for column "Due Date" to change Column "To Do" (today, this week, this month, this year)
Hi All, As mentioned in the title, trying to create a formula on the task tracker template that would toggle the "To Do" column to either "Today", "This Week" , "This Month" , or "This Year" based on the date of the "Due Date" column. Is this possible? If so, what would be the formula? Any help with this is much…
-
Is it possible to have Form fields dependent on one another?
It would be extremely helpful for me if form fields could be dependent on one another. For example, if there was a field called Geography (with Americas, Europe, Asia Pacific as the three options) a secondary field called Market would populate dependent on the selection in the Geography field. I.e. if Europe is selected,…
-
Registration for Training Events
We use Smartsheet as a registration tool for our on-campus (now virtual) training events in Research Administration. Love it! Is there any way to limit the number of people who can register for an event? We're looking for an automatic way to cap the attendance without requiring someone to check the multiple sheets all the…
-
Ignore negative: Calculate time between dates ignore negative numbers
I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell. That cell is then used to trigger an email to a user for action. If the start date is in the past the calculated days between is a negative. I want the formula to ignore the…
-
Calculating Quarters Within Dates
Hello, I'm trying to do an analysis that can calculate between a date range, specifically resulting in quarter calculations. If I have a project start and a project end date, how can I a) calculate how many quarters are stretched between those 2 dates b) if the date range (start date to end date) falls into the current…
-
Gantt Chart Markers
Is there a way to create a marker on a gantt chart? For example, the entire task timeline is 11/1/20 - 12/31/20 and I want to add in a midway point marker such as a dot with halfway there within that timeline.
-
Contact formula in a metric sheet
I have a sheet where the Assigned To can be multiple contacts. I can find the numbers for each. But it has been requested that I total each contact separately and then a row for Both. Below is the formula I am using. Any ideas how I can do it? =COUNTIF({Global Communication Editorial R}, HAS(@cell, Label@row)) Katie only…