-
Smartsheet Fails Often
And it really annoys me. Wasted four hours of my life today on a simple INDEX(MATCH()) for no reason. Here is my source sheet: Here is my destination sheet: Here is my cross sheet formula: =INDEX({JOB_QuoteNo}, MATCH([Draft ID]@row, {JOB_DraftID}, 0)) And yes, the cross sheet references are mapped correctly. About once an…
-
Prioritize by available date
I have a sheet that has multiple dates on a row, but not all will be known at the same time. I’m looking for a function or a way to provide the current best estimated date by priority. Basically, if there is a date in this column, use it, if not, use this other column, and if nothing is in either, use the date from this…
-
How to move an item in Calendar view and ensure it also updates the finish date in Grid view?
Hi Everyone, I'm working on a social media calendar. I have these columns: 1) Copy, 2) Start Date and 3) Finish Date. When I drag and move the post in Calendar view, it updates the Start date to the new day, but the finish date stays the same. What function can I use for this? Example: I have Post #1 with a start date of…
-
Count from all project sheets in the same Workspace
We have multiple projects (25+) using the same template in a workspace. I am able to create a report that shows all of the upcoming task by adding the entire workspace to the report and creating the right filters. I want to output a count of all of these tasks and use that value in a dashboard setting. Smartsheet does not…
-
Formula for Quater Dates?
Hello there, I've already built a formula out so that it includes the Quarter and fiscal year, and it works great, however I was wondering if it is possible to make this formula include the extra 5 days of each overlapping quarter? I have no idea how to incorporate this into my working formula however. Any help would be…
-
Help with IF, AND, THEN Formulas to change status column
I am stuck! I've tried multiple variations of this formula but can't seem to get anything to work. I'm looking to have the status column changed automatically based on two other columns; "Date Required" column which is a date and a "No Follow Up Required" column which is a checkbox. Here's what I'm looking for the formula…
-
Need help with a formula for the "Yes, No, Hold" column
I am using the below formula to change the Status Column from "Yes, No, Hold" depending on the various license status'. The part of the formula that is not working is " IF(AND([GL Status]@row = "Expired", [WC Status]@row = "Expired", [Lic. Status]@row = "Expired"), "No" " i have a couple rows that have expired status' but…
-
Invalid Data Type error
We cannot get the statement below to work, though it feels like it should be pretty simple. Each half of the statement works, but when put together, we get "INVALID DATA TYPE." =COUNTIFS([Director]:[Director], "John Doe", AND([Audit Complete]:[Audit Complete], =1)) Basically, we want to count the number of completed audits…
-
Using Isblank across sheets and for one column
I am attempting to have a check box populate if there is a duplicate between two sheets. I currently have it checking both sheets with this formula =IF(OR(COUNTIFS({All Dept. Contacts Range 1}, [Last Name]@row) > 0, COUNTIFS([Last Name]:[Last Name], [Last Name]@row) > 0), 0, 1) But it just checks the box even if it is…
-
Can an automation action copy data from one cell to another in the same sheet?
Hello, everyone! I am helping my boss with a new template to manage our projects. I need an automation that copies data from one cell to another within the same row based on two conditions. Without more context this will sound confusing, but I will try my best to explain. If one column is not blank, and the other column is…
