-
changing the Row number for coommets?
Hello, Is there a way to change the comments notification to show a Ticket ID number instead of the row number? So in the picture change the Row 441 to ticket ID 500?
-
Question: Hide/Unhide columns
Hello Smartsheet Gov community! I have been a Smartsheet user for many years and exclusively in Smartsheet Gov for 2.5 years now. Today one of our users shared that a free collaborator had unhid columns in a sheet. I shared with her this wouldn't be possible since only licensed users can hide/unhide columns (even with…
-
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.
-
Merged: Tracking Users' Sheet Views, Edits, Shares... All Activity
This discussion has been merged.
-
Is it possible to reset only a part of the baseline date during the project ?
Regarding the start date /end date baseline function, I'm wondering if it is possible to reset the baseline date just for a part of my planning. For example, if I plan my baseline at the start of my project for every task and I activated the baseline function, and in the realization phase, the baseline of only one task…
-
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.