-
Send an email to a contact from the sheet?
I'm building a sheet that contains various users in different roles on different teams. I'd like to email the users listed in a column when a change is made to a record. ex. I capture a program manager name in column D and when a change is made to any columns in the row, I want to email the admin (easy, set up an alert for…
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
Capacity Planning
I have effectively put several project plans in place at work. We have summary reports by assignee working really well for updating multiple projects from one report. The next step is calculating how much work we can take in with the resources we have and planning how much extra resources may be needed in the future with…
-
Magento
Has anyone got any positive experience with linking Magento to Smartsheet? eg just to populate a sheet with orders recived etc.
-
Automatically add rows when report refreshes
I have a report that's running every day against a single parent row to grab totals. A few cells of that one, single, lonely row. I'm looking for a way to automatically copy the report's information into another sheet daily, that way, over a period of 1 week, 1 month, etc., we can see the changes in the totals. This is…
-
Can you add an item in calendar view?
Can you add items in calendar view, or only edit?
-
Card View using the "Contact List" field
If a Contact List is used, would like to be able to setup lanes in cardview using this field -- easy way to tell who is working on what.
-
Excel Compatible Symbols
Hi there, I am creating a sheet for a project that I will need to export to Excel for poeple outside of my company to use and I was wondering if there are any symbols that are compatible with an export to Excel ie. would look the same. Thanks in advance, Graham
-
Count Risks only when checkbox is open
I'm trying to create a formula that only counts the risks (High, Medium, Low) when the completed checkbox is not checked off. I have a formula for counting the number of risks (=COUNTIF(Risk:Risk, "High") + COUNTIF(Risk:Risk, "Medium") + COUNTIF(Risk:Risk, "Low")) but I have another column for "completed" that I want to…
-
Inconsistency with using Fix Version as JIRA Filter in Workflow
I'm not understanding the logic used by the JIRA Filters section of the Workflow builder. I'm trying to filter by unreleased versions. In the best case scenario (which I don't think is available), I'd be able to specify Fix Versions equals earliestUnreleasedVersion() or, better yet, more operators could be added and I…
