-
How to populate valid resource rates from a source table, for each week of a project.
I have a Resource Table with… Resource ID Name DailyRate ValidFrom R01 Resource X $1,500 3/8/25 R01 Resource X $2,000 9/1/25 R01 Resource X $2,200 9/31/25 I also have a Week by Resource Table with… WeekID ResourceID WCDate ValidRatePerWeek W01 R01 3/2/25 auto-pop $1,500 W02 to W26 R01 All the dates for W02 to W26 auto-pop…
-
403 Error on PUT https://api.smartsheet.com/2.0/webhooks/<scope> beginning July 7
Zapier users are trying to setup Webhooks with Smartsheet and receiving HTTP 403 on this call PUT https://api.smartsheet.com/2.0/webhooks/<scope> (to enable the webhook) Request data is {"enabled":true} Example response data is { "errorCode" : 1004, "message" : "You are not authorized to perform this action.", "refId" :…
-
Carry over info from one sheet to another
Hello all, I have a source sheet that i trigger an form from another sheet (i embedded the form link to the email). My issue now is that i need to get the ReqID (from source) and have it read only in the new form, that will record in the destination sheet. Bottom line i need to find a way to link the ReqID from source and…
-
Alternative API endpoint for listing workspace templates after Feb 2026 deprecation?
With the announcement of the deprecation of "/workspaces/{workspaceId}" and the deprecation of the template listing endpoint (https://developers.smartsheet.com/api/smartsheet/changelog#template-listing-endpoints) There does not seem to be a way to retrieve a list of templates for a given workspace. Our app relies on these…
-
Sheet Button on Left of Sheet - Error Message
Could somone tell me what button this error message is referring to? I have an Enterprise plan and do not see anything like a "Sheet" button.
-
How to get total count for projects releasing now through the next 3 months
Hi all, I am looking to count the number of projects due to release within the next 90 days. The closest I've gotten is: =COUNTIF({HCCE input sheet Storage Range 3}, <=TODAY(+90)), but it returns a count of zero even though there are several projects within the next 90 days. Any help greatly appreciated.
-
Which is the right formula to join the text in multiple cells.
I wanted to join the text(PM names,ID) in two or more cells which is basically multivalue cells and display the same one below other and also i want the duplicate names also to be displayed
-
Viewer Seat Access: Dashboards, Forms, and Dynamic View
This discussion was created from comments split from: Licenses and True-up confusion.
-
Add Values to Each Dropdown Value
Hello, We have a Supplier Dropdown with the name of each of our suppliers. I would like to create a formula that takes each of those values and goes out to another table (Supplier Directory) and returns the City, State, and Country of each of those suppliers. I have the following formulas that look up the city, state,…
-
Updating company and email address
This discussion was created from comments split from: New e-mail (domain) change with Business plan.