Hi all, I'm a newbie to Smartsheet and am evaluating its use within our organization and so far I like what I see. As a PM one of my tasks to do project status reporting and so I had a look at the Pro…
Hi there, can anyone help me on this formula ? it looks the only issue could be on the date format but I don't know what I have to change. =IF([Expected Order Date]4 < 3 / 31 / 18, "1Q 18"; IF([Expect…
Hi, are there plans to add the feature to edit/update rows and columns through web form? it would have save me a lot of time if I could do that. thanks.
I am trying to automate RYG balls based on both the end date [End Date] and status [Complete]. I am using RYG balls for the [Status] column and Harvey Balls for the [Complete] column. If [end date] is…
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 …
Hi All, we have a simply custom API which will take as input an employees ID and return their management chain. We would like to call this API as part of a simple smartsheet form we built such that th…
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…
I'm looking for a change control form with workflow for approval. It should be tailored for I.T. Surprisingly I can' seem to find one in Smartsheet. Does anybody have a good one?
I have an issue with the charts on my dashboards not updating to show current metrics. Not sure if I am doing anything wrong but here is what I have done. 1 - Created a sheet and linked data from a Ca…