-
Card View Templates - formulas are missing?
Hi All - I am excited to implement the card view into one of our pipelines. I am basing this off of the "consulting pipeline sample" shown on the homepage of smartsheet. However, when I bring this template in, there are no working formulas for creating totals of the lanes. Am I missing something? Thanks Jef
-
When will the API get some attention?
I'm using the smartsheet library, and it works pretty well, except that checkboxes always return None, no matter the value. I submitted a bug to the repo on github, and linked it to some other folks that noted the same problem on StackOverflow. For the tool I'm trying to build, I really need that feature to work, or at…
-
Need Formula for Automating RYGG Balls
I need help writing a formula that will change the color of the health RYGG balls depending on how close to the end date we are. If end date is prior to TODAY, = Red If (Today-Start Date)/(End Date-Start Date) is greater than or equal to 50% = Yellow If (Today-Start Date)/(End Date-Start Date) is less than 50% = Green If…
-
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) +…
-
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.
-
Time stamped entries
Hi All, Is there a way to create a column with time stamp entries like the comments section? I want to make a highly visible column of entries that show when the entries were made. Right now the comments column can not be renamed or even copied. Regards Tony
-
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....
-
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…
-
If/OR formula
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far: =IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)…
-
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.