-
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…
-
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?
-
How to change my formula to flag yellow on due dates instead of red.
I believe this is an easy fix, I am just not able to figure it out! I am trying to change my formula so that the status icon does not change to red only once it is in progress for tasks due today. I would rather it show as yellow if something is due today, then red if it passes its due date. Here is my current formula:…