Discussion List
IF Formula for Today's Date between Two Dates
I'm trying to create a formula that is only triggered when today's date is between two dates. Otherwise, I want it to be blank. I want the dates to be in the cells and not just in the formula. I use this year over year and it will be a lot faster to change them for next year. I get Invalid Operation when I use the dates in…
Transfer ownership to another user using API.
We have requirement that we need to transfer ownership to another user using API. I didnt get any API for transferring ownership to another user. but i got one RemoveUser API. i tried with the api https://smartsheet.redoc.ly/tag/users#operation/remove-user But i got the below error while using the above api…
Project Management/ Time/ Expenses
What is the best way to import time/ expenses daily and have them available for the PM to view on their project? Are multiple templates necessary in order to achieve this? Thx!
Extracting Data from Multiple Sets of Brackets IF present
This formula is working great for rows where the criteria fits - but my first problem is: can it be an IF statement so rows that dont have brackets are just blank? I cant seem to make it work? Second and third problems are, how can I parse the second and third sets of brackets into their separate cells for the same…
Showing information from Smartsheet A in Smartsheet B
Hi there, Is it possible to exactly show information from a source smartsheet to a destination smartsheet? Scenario - I have two smartsheets with exactly the same column headers. One smartsheet is for the whole portfolio and displays a lot of information, currently information is copied into it from the second smartsheet…
How do I pull dates from one sheet to populate onto another sheet based on an address
Good Afternoon, I am novice to Smartsheet and require some assistance. I have a sheet- let's call it Sheet A-that has a form linked to it. My colleagues complete this form when they go visits sites, and the information auto-populates onto Sheet A. I have a second sheet-let's call this one Sheet B. I copied and pasted all…
Use Sheet Summary as Data Input for Chart Widget
PLEASE work on using sheet summary reports as data input for the chart widget in dashboards.
Get Sheet (ID) by Name using Smartsheet API
I was wondering if there is a way to get the sheet Id of a specific sheet using the name of the sheet. Get sheet accepts the sheet id to get the sheet info, but I would like to get the sheet using the name. In Bridge, you have the option to get sheet by id or name, so I was wondering if there is a way to get it apart from…
Copying Data from Locked Cell as Editor
My team is looking to lock a cell so that only admin's and owners can edit the column, but we need our other team members with Editor permissions to be able to at least copy and paste the cell and have the data move with it to a new row. Currently, an Editor cannot copy the cell and paste and have the data show up in the…
Control Center - Global Updates - Dashboard - Error
I would like to update Dashboards based on updated Blueprint. There is the error message "Failed to overwrite sight. Error (4000) durint the test update run. I haven't done much changes to the dashboard. Can anybody please help. Thanks a lot