-
Next Expense Date Formula
I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Program ( Men, Women), and Budget Impact (Income, Expense). For this formula I need to find and return the next expense date from…
-
Can we do cell links with existing conditional formats?
I am trying to link a cell with the existing conditional formats. However, linking the cell only gives me the cell value. Is there any way to get the value with the conditional formatting? ** Column "Line 3" row2 cell need to be link to column 6 raw2
-
Formula or Function to find a contact in a column
Using the error column I am trying to use a function to find a contact in the various “Shift” Columns to the left of the day off column and have it produce an error if that employee is marked in the “day off” Column . (The point of this is to have the sheet highlight if someone is scheduled for a shift on accident while…
-
Workflow Timing Unavailable - Change a Cell
I'm trying to run a timed workflow because the "PHASE 3 CELL" I'm referencing is linked to another sheet, and I know you can't run triggered automation referencing a linked cell. Any help on why I can't run this as a timed workflow? I was reading this was the workaround solution but I must be missing something.
-
COUNTIFS formula question for multiple choices
Hi there! We're trying to count together the number of projects that have final invoicing complete, meet a PO # (on that row), in addition to three different project types (Standard 2-Page Case Study, Standard 1-Page Case Study, Blog Post with Customer Review). We have the COUNTIFS formula to pull the references from…
-
Automatically populate "Duration" column
Hi all, I have a task tracking sheet, with each task having a start date, an end date, and a duration. I need the end date field to be populated based on the start date and the duration, so I set the dependencies and date range display accordingly on project settings. However, the duration of each task must be calculated…
-
Automation Question around running on a Date field
I'm working on doing some cleanup on a smartsheet that had some extra columns/automation that I don't believe are in use. I have a question around how an automation uses dates, so i'll give what is probably unneccesary background. :-) For example, in our smartsheet there is a date field called CST Due for Info Update -…
-
Keep row content with Name
I have a certification tracking Smartsheet and I was originally using an Index formula to pull names from another sheet I have, but when they get removed from sheet1 (multitracker) an issue arises. Sheet 2 (Cert tracker) has that empty name spot filled with the name below so the rows no longer match the name. I pasted a…
-
Formula to count total dropdown options in list
I have columns Skills, Total Skills, & Skills complete % I am tracking skills and I want the total skills column to auto update when a new skill is added so the total went from 30 to 31 so the completion % is accurate without me going in and manually selecting something everytime a new skill is added. I tried SUM and COUNT…
-
How to create a master sheet that can work-around the 20,000 row limit?
Hello Everyone! I need to consolidate data from two large Smartsheet sheets into one master sheet to use as a reference for another sheet. However, Smartsheet's 20,000-row limit prevents me from combining everything into a single sheet. I cannot use Smartsheet Reports as a workaround since reports do not support formulas,…
