-
Formula to calculate new date from dropdown
Hi, I have a column where a manager gives a timeframe of '1 week', '2 weeks' or '1 month' to complete a given task from their visit - how do I get smartsheets to generate a new date through a formula with one of the above timeframes chosen from a drop down and show new due date in 'To be completed by column' which has a…
-
Multiple checkboxes in one cell - Formula for True
I have a column asking three questions with the option to check one or all. Is there a formula to test if all checkboxes in one cell have been checked? I would like to apply the fomula to a symobol column where if all boxes are checked it will return a "true" value.
-
Looking for a formula to show the current status
I have created multiple approval workflows and wanted to update the current status in the Status column using a formula,
-
SUMIFS + range + criterion_range between 2 dates
Hello, community, Struggling with a SUMIFS formula. I've created a metric sheet to sum a specific column (E) in a project sheet by month. The column lists quantities for each mission (only at the parent row for each mission), spanning different months and years. While a simple SUM formula for the entire column gave the…
-
Can i get get help with a date formula please?
Hi team, what is the formula to auto populate a date based on another date? ie "date 1" equals 7 days after "order date"?
-
Change drop-down option in one cell based on data entered in a different cell
I am looking for a way to automatically select a drop-down option in one cell based on the data entered into a different cell. Monthly we track target goals against actual goals. The target goals stay the same throughout the year, however the actual goals are updated monthly. Based on the actual goals, monthy we determine…
-
Multiple checkboxes in one cell - Formula for True (Part 2)
This is a follow question - reposting for visibility. While my original question was answered, I'm now having trouble with the formula. This formula seems to be working, however I am expecting it to return symbols. Instead, it is only returning the "text". Anyone have an idea why...? The column type is set to Symbols and…
-
SUMIFS Reference Formula with two date columns and one condition. Formula is computing 0
Hi can anyone see if they can think of what might be causing this formula to compute 0 and not Summing the {Check In Log Range 1} {Check In Log Range 1} = Dollar Volume {Check In Log Range 2} = Employee Condition {Check In Log Range 3} = Start Date {Check In Log Range 4} = End Date =SUMIFS({Check In Log Range 1}, {Check In…
-
How to Sum Across Multiple Sheets?
Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sheet 1, 4 hours in Sheet 3, and 24 in Sheet 5 for a grand total of 40. I want to be able to summarize total Effort for each…
-
Is there a way to have completed tasks in a sheet either obsolete or move to the bottom of sheet?
Is there a way to have completed tasks in a sheet either obsolete or move to the bottom of sheet after a certain amount of time has passed?
