-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Smartsheet integrating with gmail add-on error
I get an error message randomly when I get to the final step in adding an email to my sheet. It says - Your changes could not be applied. Please check “. This doesn’t happen all the time and is not consistent.
-
Delete multiple comments?
Hello, all! We created a copy of a 2020 sheet to make a new one for 2021 because so many of the tasks are recurring; we're merely updating assignees and task dates in most cases. However, we're now left with several comments and attachments throughout the sheet that we need to delete because we copied the full sheet. Is it…
-
Health of Task or Project using % Complete & Finish Date - Sanity Check
I found something close to what I am looking for here: NEED HELP: Health Formula based on start date, end date, and %100 complete needed. — Smartsheet Community This formula doe s a great job of flagging the dates in relation to time left. However, I am looking for a health check that can take into account both percentage…
-
Sharing Recommendations and Limitations
I'm rolling out a new process with a client and constantly finding areas where I need to use a work around, only to find that solution won't work in another aspect. For example, I have one sheet with sales data that needs to be updated constantly by the sales team, however, I don't want them to have access to the sheet,…
-
Current User/Alert Someone Automation
Hi, I have an automation that any time a comment is made a contact listed gets an email using alert someone. The issue is the email links to the report but the report is so large it is difficult to then find the comment that was made. Is there a way to make the link or report more defined when they go to it? Or at least…
-
Comments feature - turn off forwarding capability for "viewer"
We shared a sheet to a viewer and it appears that not only can they view comments, but they also have the ability to forward them. We'd like to avoid the forwarding, if possible. Is there a way to turn off this feature?
-
Can I add comment to a cell?
How do I add comment to a cell? similar to how its done in excel.
-
How to copy emails into comments?
I am not sure if this is an option yet or will be at some point. But I would like to have a unique email address per row in a Smartsheet. So as we have email conversations I can cc a unique email such as (UserIDSheetRow@smartsheet...) and that email would be stored in the comments section. Is this an option or soon to be…
-
Newbie: Can I have row comments automatically populate a "Comments" column?
Hi...I'm sorry if this is a stupid question. I like that the comment tool allows multiple lines of commentary from a single person vs the limitations of trying to add notes in a "Comments" or "Notes" column. Is there a way to get those comments to populate a column in the spreadsheet (or a report?) so you don't have to…
