-
% Date calculation
Hello, I need to create a % calculation for the number of dates meeting a 'launch' date. What is the best formula to use for this? I will have a long list of dates and I need one column to calculate how many of them are equal to or less than a launch date (25/03/2021). Any guidance would be greatly appreciated. Thanks,…
-
vlookup vs. Match (identifying new form submissions compared to a static list)
Scenario: * I have a list of 200 customers that need to be surveyed by our team. * Some customers will receive multiple surveys, as they are served by multiple team members (our plan is to compile & analyze the results). * Although to meet our goal, only 1 survey per customer is needed * We are using a Smartsheet form to…
-
IF Statement to return a Date value
I'd like to create an nested If Statement to return a date based on meeting a specific condition. I'd like to be able to "hardcode" the date in the IF statement. Here is a quick example =IF([Value]1 = "Option2", 4/23/2019, IF([Value]1 = "Option2", 4/24/2019, 4/25/2019)) . If the date is quote wrapped ed "4/24/2019" then it…
-
Formula to count number of task
Hi, I need help with adding a formulat to count the number of task. I tried adding the formula but it didn't count the task it adds it to the number of task for the above row. I'm fairly new to smartsheet so it's taking me a minute to figure out the formulas. Any help will be great appreciated. This is the formula I used.…
-
CHILDREN formula in parent row with a Status column
Hi, I'm trying to add in a parent row, as a Status cell, this kind of formula: If any of the children have 'In Progress' or 'Complete' in a 'Status' cell, then in the parent's 'Status' cell, should be 'In Progress' OR all of them have 'Complete' in a 'Status', then return 'Complete' OTHERWISE return 'Not Started' (doesn't…
-
Auto Checkbox Formula
Would you help with an auto checkbox formula please? I want a checkbox to automatically check yes, if the sheet is 7 days past the created date and another checkbox in another column is not checked by the 7 day mark.
-
Dashboard
I am trying to create a widget on Dashboard for project progression that includes factors such as "Total development cost to date" "Total development cost this calendar year" "Future spending in next 1,2,3, months". How do I program the cells in sheets to reflect these dates (ie. todays date plus 20 days for next months…
-
Formula to find in Col1, output Col2 of same row to Col3 of different row?
I have content in one row with a Title column and a Description column. They are related, but the Description is only populated one time but relevant to any content that has the same Title. How can I write a formula that says "if (specific)Title, output the content of related Description" to "Output"? The Title occurs…
-
Check if one contacts column matches another
I want to set up a notification for when a row is modified by someone NOT in a contact list column of "assignees". The idea is that if someone not in the assignees cell modifies the column, then I would notify the assignees. I was trying to set up a helper column that would calculate if a "Last Modified By" system column…
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
