-
Emailing comments
I have tried emailing comments and tagging people and they are not getting the email notifications. Is anyone else having this problem?
-
If/And formula
Hello experts, I know this question has been asked before. But I have been trying for a while, and I can't figure out what I am doing wrong. I Need to create an IF formula with 2 criteria. If my target date is empty and it is greater than today, then don't do anything, if not return a 1. attached you will see a print…
-
Report that features tomorrow as due date
Trying to create an automated report that pulls items from multiple sheets with a due date of tomorrow only. I have one that does the same for today, but tomorrow has proven to be more challenging. I could manually update the report every day by changing tomorrow's date, but I'm trying to avoid that. And using "is in the…
-
Sunday IT operations
Hello, I would like to know if there is a way to force a task to be planned a particular day of week (sunday in my case) ? Saturday and sunday are not working days but for special IT operations we need to work a day off. Thanks for your replies.
-
Create from Template can only save in "Sheets"
I have created a template that we use for creating new sheets. The template is in a workspace where new sheets that are created should be saved to (within sub-folders within the workspace). I have a licensed user who is also an admin and when they create a new sheet from the template and hit "Browse to locate where the new…
-
IF Formula returning as Unparseable
Good afternoon everyone, I am having a heck of a time trying to figure out why my formula keeps returning as #unparseable. If a Category says Expedite, the cell needs to show $25.00, if not, it needs to show $0.00. My formula is =IF(Category1 "Expedite", $25.00, $0.00). I've tried removing the dollar signs, the decimals,…
-
Jira Connector - Epic and FixVersion Conflict/Issue
When setting up a query to pull all issueTypes and fixVersions the query fails (and workflow is disabled) with the following error: "Your workflow has been disabled due to the following error: Invalid mapping or filter configuration. Unable to fetch value for column 'Fix Versions'. To correct this issue, please log into…
-
Smartsheet cell data linking to excel or word.
Hello to all. We are about to jump into smartsheet use for our company, however I would like to know about functionnality: is it possible to link certains Sheets data to a Word or Excel, offline template, in export ? Here is a usage scenario : We do need to manage IT rollouts projetcs, with Site surveys, Installations, and…
-
Check boxes to equal complete date
Hi! I have 7 columns that have check boxes. When all 7 columns in one row are all checked, I would like a column that will auto populate a "completed" date. Is this even possible or am I insane? haha! Thank you!
-
Drop down Cell calculation
Can anyone explain how to create a formula for adding up amounts from a specific cell that is a drop down? For example I have multiple clients that I can select from my drop down list. Each time there's a transaction from that specific client, I want to have the amount calculated in a separate column. How do I add the…
