-
Get Earliest Date from Range Given a Second Criteria
Hello, I have a column of Dates and a column of Names. What formula can I use to return the earliest Date from the Date Column for a given Name? Thanks.
-
Welcome to Just for fun - let's post some memes!
Hey everyone, welcome to the Just for Fun Topic (formerly known as a Category) which is just that - a place for all of us to take a breather and have a laugh or two. To start, let's go with the Internet's chosen love language: Memes. What's your favorite Smartsheet meme? Drop it in the comments (keep it clean please!).…
-
Is there a way to archive a workspace
-
invalid data type
I keep getting "invalid data type" with this formula: =INDEX(COLLECT({Time Audit Overview %Accurate}, {Time Audit Overview start date}, AND(YEAR({Time Audit Overview start date}) = 2024, MONTH({Time Audit Overview start date}) = 12), {Time Audit Overview restaurant}, [Restaurant Name]@row), 1) I have checked that my "start…
-
Web Content Widget not working
Hello, I'm trying to add a view-only version of one of my sheets in the dashboard. Using the Product Development Roadmap Dashboard template from Smartsheet itself, I see that I need to use something called 'Web Content Widget'. I don't see that option when I open the Add Widget pane: So, I tried to go inside the widget…
-
NEW! Your survival guide to formulas is here. Meet the Formula Handbook.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: A glossary of all…
-
Countifs formula
Hello, to this formula how would i add another sheet to get the match from? this formula says: match employee name, and if the column (sheet 1) has this document title return green, if it doesn't return red (sheet 2). Now i would like it to do the same thing but from a different sheet and return to the same sheet?…
-
Formula Help
I think this should be a simple formula but I am getting a circular reference error. Can someone help? When the DocuSign status is sent then I would like the status column to change to "Pending Sig. Approval" =IF([DocuSign Status]@row = "Sent", "Pending Sig. Approval", [Status]@row)
-
No Predecessor but Date Cell won't change
I am working on a schedule and have a row with no predecessor, however the "start date" won't let me manually change it. It keeps auto-correcting back to the same date that has been in it from the beginning. Any thoughts?
-
If Formula
=IF([Work Performed Total]@row / [Employee Count]@row * 12 = 0, [Revenue Projection]@row / [Employee Count]@row * 12) Why is it if the work performed cell is greater than 0 then the answer is blank? I want it to use revenue projection as the normal answer until work performed numbers start getting entered
