Hi, I have a date column which lists down all the dates in the year and a checkbox formula. In the checkbox column, I would like to insert a formula that would perform the following function for me: I…
Hi, I'm working on developing an induction booking process that allows our team to book site induction through Smartsheets. Firstly, I intend to have a Smartsheet induction register that will include …
Hi, I have created a chart widget in Smartsheet dashboard and I would like the horizontal axis to go up to the value of 100 only and not 120. Is there any way to bring it to 100? Please see attached i…
Hi, Has anyone part of the community done any sort of integration between Smartsheet and the online accounting software - Xero? I have come across websites like Zapier that can do the job for me but t…
Hi, 1) I have sheet "X" set up as shown in screenshot 1 below where I have got a start date and end date column and the week numbers associated for the date ranges. 2) I have got another sheet "Y" set…
Hi, I have just added a new auto number column in my sheet and although I left the "fill" and "suffix" section blank, when I click on save the numbering in the column starts from "KX BOND 478" rather …
Hi, Is there a possibility to share just the report without providing access to the underlying sheet to key stakeholders? I know that this is possible using the dynamic view add-on but does anyone hav…
Hi, Is there any way to make the category field and the risk level field mandatory for users to complete before they can change the status from open to closed in my Smartsheet? Currently we have users…
Hi, Can anone please suggest for my sheet that is formatted as shown in the attached image and for the following conditions if risk/issues cell is not blank and due date is in the future then yellow i…
Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", …