-
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…
-
Extract selected data from sheet (without using report)
Hi Smartsheet community! I have the following problem: I have a Smartsheet with a long list of items. These items will be shipped in several shipments and several collis, on different dates and to different locations. I would like to extract an shipment overview from this complete list of items that only includes the…
-
Gantt Chart Formatting Gaps
Hey, I have been making some project programmes for my boss to present and there are occasional (seemingly random) lines running down the gantt chart. Some are at the end of a week some are at the start of the week, they are all of different widths. When the chart is exported and printed it is very distracting and I don't…