-
Formula assistance
Hello, I am needing to pull count for the current month and year to track my extensions for each project. I am unable to capture the formula correctly. Any guidance or assistance is greatly appreciated! This is where I am pulling the data from -
-
Please help with Parent-Child Circular references
I am trying to create a sheet in which the latest data from the child rows is presented in the Parent row so the most current info is always displayed in a collapsed row view. I have several columns I need to "pull into the parent row. I successfully got everything to work as desired. As soon as I tried to copy the…
-
Datashuttle: source not found when updated
I have a situation where a SharePoint folder is updated every week by uploading a file with the same name and columns each time. I have set up a Data Shuttle to upload this data to a datatable, but it doesn't work because the file is deleted and replaced. What other solutions do you suggest?
-
Whats wrong with this nested if and vlookup formula?
Hi - I am trying to have my smartsheet return the monthly budgeted cost for each test kit (covid, flu, strep, RSV. Each month has a different budget allocated to each test and these are in a separate sheet. I tried the formula below but it is returning as "unparseable". Can you please help me identify what I am doing…
-
Quick Tips and a list of Frequently Asked Questions
Quick Tips for engaging in the Community 🔎 Search before you post: Before you create a new post, search to see if your question is already out there. 💬 Be descriptive: Include screen shots and as many details as you can when asking questions or providing an answer (without exposing sensitive data). The more details you…
-
🚨 New Community Topic: Community Job Board
Hi Smartsheet Community, You shared your interest in sharing and learning about work opportunities in the Community — and we loved the idea! We are excited to introduce our newest topic: Community Job Board. The Community is full of talented Smartsheet experts, not to mention passionate professionals from all industries.…
-
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!).…
-
CountIF Month AND Year
Trying to perform a CountIF AND function where a cell counts the reference cell containing a Specific Month and Specific Year. The following formula is returning unparsable error: =COUNTIF({EHS Visit Tracker - DoV}, IFERROR(MONTH(@cell), 0) = 1), IFERROR(YEAR(@cell),0)=2020) Can you help?
-
New reactivation policy for deactivated users
Hello! I am trying to figure out how/why this new policy was started and how it makes sense. When we have users that are eligible for rehire, we deactivate them and then reactivate them when they are rehired because we use the same AD stuff (even if it's been a couple years). No issue, we're good to go. Now, the policy has…
-
Check box if date is equal to or between dates
I want to create a formula to do the following: If the "Created Date" is equal to OR between the "Week Start" and "Week End" dates, I want to check the "Submitted on Time" box. I tried =IF([Created Date]@row, >=[Week Start]@row, <=[Week End]@row, 1, 0) and am getting an INCORRECTARGUMENT error. I'm sure I'm missing…