-
Formula Syntax Help
Hello, I am creating a sheet to track calibrations for the equipment in our department. I saw the function to add months to a date from another cell https://community.smartsheet.com/discussion/smartsheet-formula-syntax-help =IF((MONTH([Purchase Date]1) + 9) > 12, DATE(YEAR([Purchase Date]1) + 1, MONTH([Purchase Date]1) +…
-
Feature Request - Combine row with discussion in notifications
Could not find this in the forum. Hope it's not a reapeat. So, we use SS to track multi-room multi-year projects with 10-15 people reporting on a site per day. As each person may work on several rows that day, there will be changes to the rows and changes to the discussions. Then, when the daily report comes out and you go…
-
Lead time Formula
Hello, I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and in another cell we would…
-
API to apply conditional formatting
I am not able to find how to apply condiional formatting via API. I have various sheets that I want to update all at once and apply different conditional formatting without having to do it via the interface manually.
-
New Client Sheet Generator?
Hello, I have a Web Form which Account Managers complete when a new client is to be added to a 3rd party tool. This data transfers to a smartsheet where an email is sent to our 3rd party tool notifying them there is a new client. This data contains the client name, address, phone, email, and POC. At this point, I am…
-
Formulas to calculate data received from web form
This is a screenshot of my page that I want to try and get the formulars for. The cells that are in yellow, the data in those cells will come from my staff that I have complete the web form that i have attached to this sheet. The red cells are the ones that I require the formulas for to calculate the different times that I…
-
Name instead of email address of the person created the row
I used this "Auto-system - created by" column property and what appear in the column is the email address of the user who collaborator who created the row. Is there a way to changed it instead to the name of the user who created the cell. Thank you.
-
Sorting Capabilities Changed?
Since the newly updated sheet, I can not for the life of me sort a column. I know I have to remove all filters but the option to sort is still greyed out. Please advise....
-
Use cell links in formulas
I'd like to suggest as a new feature request the ability to use cell links in formulas. There are many occasions when I would like to sum the values from multiple cells on various sheets into one cell on another sheet.
-
saving docs in Workspaces
fellow SS users, My colleague, who has full admin rights, is not able to save anything into a workspace that i have created. I can't see any restirictions in any settings so I wonder how I allow him...and other license holders, to freely add to and use this space. Thanks, Si.
