-
Help to create a formula that sums a column based on if values in two other colums are correct.
Hello, I have three columns that need to be in a formula. TIME, Y, Z I Want to SUM all the rows under the "TIME" column based on if the Y and Z columns have the specific dropdown value. This was my try but it did not work: =SUMIFS([Z]:[Z]; "Approved"; [Y]:[Y], "", Time:Time) Can anyone help? Kind Regards, Hugo Martinwall
-
I can't see/manage my Alerts & Actions
Hello, I have a problem concerning Alerts & Actions. When i first press it in the toolbar I can see that I have 10 Rules. But I can not go further to manage them. Anyone experienced the same problem?
-
Unable to save data to the database
I created a new workflow/smartsheet. Filter seems to be ok and update summary comes up with the correct amount of rows and information. But when I select Save Workflow it complains with !An error occurred, Unable to save data to the database. Anyone else having this problem?
-
SUMIFS Issue
Hi, I have a client master list on my Smartsheet and I want to get the total monthly fee of those clients that have an "Active" status Both the monthly fee and status are in my Smartsheet and when I tried using =SUMIFS(MONTHLYFEE:MONTHLYFEE,STATUS:STATUS,”Active”) I got an #UNPARSEABLE error. Please help. Thanks!
-
%Complete forumla reflective of sub tasks Complete
I am looking for a formula that will help me achieve a percentage complete column that will reflect the number of subtasks complete divided by the number of subtasks. For example: Parent folder with 3 subtasks Status of 1 subtask is complete Percentage complete column will reflect 33 percent complete Any help would be…
-
Smartsheet API - document generation and attachment to row.
Been struggling a bit with recent smartsheet api development and was hoping for some insight as to how to handle the following situation: To bypass the restriction of 5000 rows per sheet, I'm developing an app using NodeJS sdk that will run on a scheduler in the following fashion: If row count is 4500, next time this app…
-
Import contacts for templates
After importing contacts (csv file) into a sheet we're using as a template and then sharing that sheet for others to use, is it possible for the contacts to remain in the template? I am trying to eliminate every smartsheet user from having to import contacts individually and simply do the work upfront on our templates.
-
Help Desk Dashboard
Has anyone created a Dashboard that links to a Help Desk SmartSheet? I'd like to be able to have a Dashboard that shows users the status of all tickets submitted, so that multiple tickets aren't submitted for the same issue.
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
STS dots
Is there a way to add another color dot to the Drop down, or select a new one with 5 colored dots for the STS column?
