-
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…
-
Data Entry With a Filter
OK - I have a sheet that tracks our invoices by VENDOR. We have several vendors in alphabetical order as the "parent" rows and underneath each vendor are their respective invoices (children). The sheet is long so I create a filter to pull up a specific vendor. In the first blank row under that vendor I type in the…
-
Can I connect and initiate a Datamesh config using Zapier?
Can I connect and initiate a Datamesh config using Zapier? Every time I add a new row to Sheet A, I'm using Zapier to create a new row in Sheet B. Sheet B has other columns that need to be updated from Sheet C, by "joining" specific columns in Sheet B and C using the Datamesh. How can I achieve this with Zapier or…
-
question about countifs
I'm trying to count the number of checkmarks for departments. Essentially, for this screenshot, the Academy project has people from different departments participating. I want to know how many people from each department are working on it--a count of each. That way, when I add more people to the project, the total counts…