-
Join Collect
Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet. Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeepers that work on the project. Normally I would use Index Match however, some clients…
-
Webhook callbackUrl Port Support Query
Hi All, Raised two cases with Support but no response so starting new discussion. We have created smartsheet webhook with callback url having port 443, 8008,8000 and 8080 but able to get response when callback url configured with 443 (tried one by one port, doing PUT { "enabled": true } after creating webhook). Do other…
-
Why are my Parent rows constantly expanding when the Filter is turned on?
Hello, All of my Parent rows are expanding automatically when I have a filter on. This happens every time a member of my team refreshes the page. Is there a way to have my filter on and keep the Parents rows from expanding automatically?
-
Using Smart Sheet and Web Form to manage testing
Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing same test case? I'm currently using a reporting template but there are numerous…
-
Auto fill cell value if adjacent cell matches cell in another sheet.
Hello, I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on my main RFI Log. my main log: 1st column is RFI #, and 2nd column is internal…
-
Checkbox to equal 100% in % complete
I am attempting to do the following. If the "Completed" column has a check, in the checkbox, I would like the % Complete column to read 100% Here is the formula I thought would work using task 4.of the project. =IF(Completed4 = "Complete", "100%")
-
COUNTIFS, WITHIN DATE RANGE, ISBLANK FOR ADDITIONAL DATE RANGE
I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank. Project Status = Active Schedule Complete Date = 7.1.20 - 7.31.20 Actual Complete Date = Blank Here is the data and fields I would…
-
Renaming Workspaces
Is there a way for admins on workspaces to be able to rename them, or is it only workspace or sheet owners that can do this? Since the admin has full sharing/editing rights, it would be helpful to have them be able to do everything the owner can do so there isn't a bottleneck with every change having to go through the…
-
Combining Two Sheets into a Report
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - while continuing to maintain the two task list as separate sheets. I tried to create a…
-
Need Workaround Ideas for Automation Condition
Client submits file through form. I have an automation set up to respond to client when new file w/response is attached to row and "Status" and "Date" cells @row are populated. It works as intended but relies on people to always set those 2 fields and save before attaching the file to the row. Without the conditions set,…
