jg124✭✭✭✭✭

@Andrée Starå @Paul Newcome with the recent updates to workflows is there now a more straight forward way to record if someone checks a box?

Hey @Andrée Starå Just had a look, don't think that will work as it is just recording dates (but can think of other use cases where I will be using that ) I'm looking to count where string items highlighted orange are consecutive and = to "This Week" column on my sheet. For example, if the W39 = W40 & W40 = LastWeek &…

Hey @Andrée Starå I'm not too familiar with the Record a Date feature, could you please elaborate? Is this a new(ish) feature? Have not come across it yet! Thanks

@James Keuning thanks for you reply. One last question - does the connector work both ways i.e. update Smartsheet, changes reflected in QlikSense & Update QlikSense, changes reflected in Smartsheet? Or is it just update Smartsheet, changes reflected in Qlik? Thanks! :)

@Heather D thank you so much, I was nearly there ! :P @Paul Newcome we are manually entering it in to a Grid, any suggestions/ improvements from a master such as yourself are always appreciated!

@Andrée Starå no problem, I must do some homework on the API!

@rjudenberg thank you, did not know the VALUE function existed!

@Anirudh could you please share how you did it? I am using pivot app that is importing dates from a sub sheet in yyyy-mm-dd format and need to convert it to a date for the date column. Thanks!

不用担心@Paul新来的谢谢s for getting back to me!

@Paul Newcome @Andrée Starå has there been any update on this since? I'm looking to automate indentation when a row is marked as complete. Due to calculations being linked to this sheet I need to keep the completed items on the sheet (indented) Just wondering, thanks! :)