-
Sales Totals By Year and Month
I'm trying to summarize our sales totals by year and then by month, based on a joining of the year and month from a "current ready to ship" date column. I'm using this for the January 2017 total cell: =SUMIF(yearmonth14:yearmonth51, LEFT(@cell, 9) = "2017 - 1", [P.O. AMOUNT]14:[P.O. AMOUNT]51) This method works just fine,…
-
Working with SS API SSL Error
I am trying to access my smart sheet from a php program via the API. Every time I run the program I get the following error, any idea why and how to fix it? (Bearer is my token) Error:Unknown SSL protocol error in connection to api.smartsheet.com:443 <?php $ch = curl_init(); curl_setopt($ch, CURLOPT_URL,…
-
Using Lookup Function
Hi, I am a new user to Smart Sheet. I am trying to use the lookup function for a value in another Smart Sheet. I want to search for the name in the current Smart Sheet over in another Smart Sheet and when a match is found, get the value in Column 6. I have searched the help section but can't find an example of the lookup…
-
Sum columns for each month
I would like to summarize the cost of each month in the current year. columns for each month and year. I do not get the formula: =SUMIFS([Totalsum eks. mva]29:[Totalsum eks. mva]1403; Start29:Start1403; MONTH(@cell) = [Årlige utførelser]28; YEAR(@cell) = [Måneder for utførsel]28) Please come with suggestions
-
show the latest date from 3 selected columns
I would like to show the latest date among 3 selected columns in a new cell, Is there any formula to make it happen?
-
Give access to a WorkFlow?
We have a few shared sheets for which we need to adjust the Jira Workflow from time to time. Currently, the creator of the workflow is the only one that has access to it. Is there a way to share the workflow with others so that more than one person may make changes? Thanks.
-
Auto populating Formula Issues
I have an existing sheet with formulas to compute "netdays" left for a task, the task and variables live on the same row. That sheet has a form which allows for a user to add to the sheet a new task and assign, within the form, a start and end date. These dates are the variables that contribute to the formula. My issue is…
-
Incorrect Counting of Empty Rows
I am trying to count blank dropdown values in a sheet by referencing the column and it is giving me incorrect numbers. =COUNTIF([Sign Off]:[Sign Off], 0) It seems to be including the 10 empty rows at the bottom of the sheet too. Does anyone know how to get around this?
-
Receiving Reminders Not Receiving Notifications
Hi, I have an email address ("Support") shared to the Workspace. It is receiving reminders (reminder@smartsheet.com) but it is not receiving notifications (notification@smartsheet.com). The notifications are not going to junk mail. Nothing was on the "Safe" list of the "Support" box but reminders were coming in. I added…
-
Dashboard/Sights as templates
Hello all, is it possible to save dashboards as templates? I want to make different sheets with the same template and different data, but also have the same dashboard and different data for each of them, is it possible to add the dashboard as a template and automatically have them connect to the data of the sheets? Kind…