-
IF function to return value based on dates
I am trying to get a value when I put in a particular date If a person puts a date in the Target completion field, I want to return a Sprint in the Sprint field. I dont know if I can use the month or does it have to be between? For example =IF([Target Completion Date]@row) is between 8/1/2024 and 8/31/2024 then return…
-
Sending a single email to multiple people
Hi, I have several automations set up to email coworkers. However, usually I need everyone to be literally on the same email. I understand that ultimately smartsheets wants/thinks people are going into smartsheets to "work" but sometimes that's not the case, sometimes you have people outside your organization or whathave…
-
I want to count items within current month without needing to change the month manually
I need to report on the number of items that appear in the current month to date. Is there a formula that can be applied without necessitating manual entry of changing the month manually?
-
COUNTIF with HAS formula
Hi, I'm trying to use a COUNTIF formula with a HAS criteria, but it doesn't seem to be working for me. Would someone mind taking a look? I'm trying to count the number of times "Apples" shows up in the multi-select column, Range A, while Range B also has "On Hold." Here's the formula: =COUNTIFS({Range A}, HAS({Range A},…
-
Exclude cells with no data?
What function can pull this math but only for cells which have the date in it? I'm just trying not to see an invalid alert on everything - only some projects will have data in the cell referenced for WORKDAY.
-
Rearrange Home Page to Clearly Show Shared With Items
Home page should show "shared with you", "owned by you", "frequently opened", "favourited" and/or pinned sheets/documents. The current "suggested for you" seems to create much confusion in my team as to what they do and don't have access to. Maybe even include some upcoming reminders in the home page or pending requests.
-
Merged: Increase Functionality on Reports and Project Plan Sheets
This discussion has been merged.
-
Dashboard integration with powerpoint - or print preview function
Currently to load our projects from a dashboard to powerpoint we 'print to pdf' and then snip to paste to power point. Is Power point integration a reality? If not is a print preview function possible to clearly show where each page cuts off? This is a monthly cycle for my team to reformat/respace depending on the amount…
-
Form Names - Independent of Form Title
My suggestion is to allow forms to have a name that is distinct from what shows at the top of the form. We often use multiple forms for the same event to track which marketing avenue led to the registration, such as Facebook, email, etc. We need to distinguish which form is which when managing the forms but would like that…
-
Customizable Sheet View(s): save specific hierarchy layout
It would be helpful if sheet users could create, store, and share customizable views within the sheets, similar to filters. I'm NOT referring to views such as grid, Gantt, cards, etc. This is different. For example, I have a Schedule template with 300+ rows. Current functionality allows me to Expand / Collapse All, but I…
