-
A-Z Rows
hi ive set up a couple of new sheets and looked to sort the rows A-Z but wont allow me? any ideas to fix this problem ta
-
Indent/Outdent
With the new format of the tool bar (now a ribbon at the top), I can't for the life of me find a button to indent/outdent to create tasks and subtasks. Can anyone point me in the right direction? This is a trial version... am I missing some of the key functionality?
-
validating cell value
Hi, I have a sheet with diferent columns, one is "Initial Date" and other one is "Ending date". How can avoid users update "Ending Date" with a date earlier than today?
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Linking to a Smartsheet functions
I've seen posts that contain links that create an action, such as "click here and a copy of that sheet will appear in your instance of Smartsheet" I cant find the OP, and cant recall if she was staff perhaps, but the link worked. Is it possible then for me to create links to actions, for instance a link from that would…
-
CORS in Ionic and third party api(Smartsheet)
I am trying to get data from smartsheet API. When I use postman and nodejs in separate server code, it works. But if I use the API inside the Ionic with HttpClient (@angular/http) it gives CORS issue with run in browser. Failed to load https://api.smartsheet.com/2.0/sheets/1235941564208899972: Response to preflight request…
-
Feature Request: Allow a Comments field for the entire sheet
It would be great if I could look at the sheet properties and have a section to place a comment pertaining to the entire sheet - sometimes it's useful to have a note on the purpose of the sheet and other useful information for users. The comment would apply to the entire sheet not just individual rows.
-
"If clause" in Dependancies
Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be completed. If no, then sheet 3 will not be necessary. I can't see an efficient solution for this. Any suggestions? Thanks!
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
RYG Status Formula
We have two set of data that are required. Count column that is 0 until there is entry into one or all of the previous columns. This formula provides a count (this formula works fine) =IF(Series5 = 0, IF(COUNTIF([SKU 1]5:[SKU 15]5, "") = 0, 1, 0), 1) In the RYG column I have this Formula. =IF(Count5 = 0, "Green", IF(Count5…