-
Column ID visible in Column Settings
The column ID has been removed from the Column Settings. It is now accessible only through Bridge. I would like to request that it be added back to the Column Settings.
-
Formula that would look at the keywords for that row
This discussion was created from comments split from: Add JOIN Function to Index/Match.
-
Can you use data shuttle to migrate smartsheets from one server to another?
Our organisation has been merged with another, and we need to migrate a huge raft of existing live smartsheet project plan data, reports and dashboards from US servers over to smartsheet on UK servers. A number of us have licences for both versions to enable the migration, but we need to complete in the next 3 months. We…
-
=COUNTIFS formula and referencing another sheet. Getting error message: #INCORRECT ARGUMENT SET
Good morning! I'm using =COUNTIFS formula and referencing another sheet. One of criteria is result of a checkbox column. =COUNTIFS({ETSI Contract Tracking Range 2}, 1, {ETSI Contract Tracking Range 5}, "1 way NDA") Range 2 is checkbox. I want to count those that are checked. Range 5 is column that contains Type of Contract…
-
shared template and workspace
I have 2 new licensed users that I added to the workspace folder and a template. They can open the template but they can't save it to the correct folder. How can I remedy this?
-
Resource Managment API - Reports
When connecting to the report rows endpoint, I am receiving an error when using the timeframe as shown in the API documentation. "time_frame":{ "from": "2022-01-01", "to":"2022-12-31"} Error message received: {'message': 'to is not a valid time_frame'} The API works without error when using one of the canned strings such…
-
#INCORRECT ARGUMENT SET
Hi Team, I am trying to fix this formula but it keeps giving me an error #INCORRECT ARGUMENT SET Could you please help me fix this one it's kind of urgent to close. =IF([Calculation of Receivd to Warehouse]@row >= 31, "Delayed", IF([Calculation of Receivd to Warehouse]@row <= 30, "Expected next 30 Days", "Green",…
-
Can I add HAS formula to this existing formula?
I have a formula that pulls hours from one sheet if the department has been selected in a dropdown but the problem is that it has to be a single dropdown and we have multiple departments that could be working on the same project. I would like to find a formula that can pull the hours from the week but from a multi select…
-
Email Invite not transmitting to a license user
Why would an email invite show 'pending' for days? Invitee not receiving the invite. Confirmed email is correct with user.
-
Formula not calculating for each row automatically. Have to fill down.
Have a sheet that is populated by a form. The sheet has a column that has the formula: =IF([Tier Score]@row <= 17, "Tier 3", IF([Tier Score]@row <= 25, "Tier 2", IF([Tier Score]@row >= 26, "Tier 1"))) But when someone submits a new row, the formula does not fill down to calculate. I have to manually fill down.