-
How to count a text in a column?
Hey there, I'm trying to count a specific initials in a column with multi initials in each cell, but it doesn't work. Please check out the image. Is that a limitation? Thanks.
-
Formula Suggestion: [Column Name]@ to Imply "[Column Name] in This Row"
In Excel 2010, a simple and powerful feature was added to formulas used within tables: the @ prefix. All @Column1 means is this row in Column 1. It greatly simplifies the reading of formulas, and I would wager that accross the entire spectrum of Smartsheet users, most formulas are referring to cells within their own row.…
-
Date Formula Reminders
If you set up a date on a formula, can Smartsheet still use a reminder. The questions is here that actual text in the date field is a formula displaying a date. The items are not showing up on the calendar and that is concerning. Thank you in advance.
-
Combine 2 IF formulas
Hi, Can someone help me with combining these 2 formulas? =IF(MONTH([Date Raised]12) = MONTH([Date Raised]1), "Yes", "No") and =IF(YEAR([Date Raised]12) = YEAR([Date Raised]1), "Yes", "No") Regards, Samad
-
Counting rows between two sets of dates
Hi Smartsheet Community, I'm trying to figure out how to count a row if the date column falls between a set of dates. Basically, I'd like to use the COUNTIF formula and count the row if the date is between 07/01/17-09/30/17. Any ideas on how to do this? I'd rather not add in an additional check box, just base the formula…
-
Help With Formulas
I am attempting to automate the RYG column shown in the screen shot below. I need the formula to look at the finish date and status columns if the status is not "Done". I need some feedback on the formula that I am using below. =IF([Finish]1 < TODAY(), "Red", IF([Finish]1 = TODAY(), "Yellow", IF([Finish]1 > TODAY(),…
-
Reminder when items assigned to user
Hi All, This is probably something easy to do, but I'm still a little new to SS administration. I have a issues log that has a "Assigned To" Column (using contact list) and a "Modified Date" (system). I am trying to find a way to send the "assigned to" user a reminder email anytime something has been modified and the…
-
Filtering for a Particular Value When Multiple Exist
I am using a text type column to populate multiple values that I would like to be able to filter on. However, the values have letters and/or numbers that because of schema show up in the Filter output that are not desired. MS Project uses commas (and some other values that you define) as separators. Does Smartsheet use…
-
Totals by month
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows…
-
Allocations
Scenario 1 I have a task that happens every Tuesday but only takes 1hr of my time. I don’t want to create multiple rows to indicate this as one 1hr of the day, is there another way to do this? Scenario 2 I have task that happens with a span of 5 days but only takes 3 hrs how do i calculate that? Is there a way to do this?
