Monthly Management of Projects
Hello All, I am now responsible for reporting on the progress of multiple projects in our organisation and what is going on. I have created Sights for each that roll up into an overall position to save time and effort. However, I would like to create a task list for myself to make sure that i have covered all bases on…
Prefill Webform with QR Code
Hi all! I've been playing around with webforms and data stored in QR codes for my company. What I've got is when I scan a QR code, it sends me to a Jotform survey that pre-fills fields from the QR code into the form fields. For example, the data stored in my QR code looks like…
Checkbox Parent Cell if any Children cells are Checked
Hello, I am looking to use a formula that will check the box of the parent box if any of the children boxes in the same column are checked. Can anyone help with that? Thanks
Countif with Dates, Smartsheets keep adding blank lines, Invalid Data Results
Hi Guys, Firstly, thanks for the help. I am trying to add records and have cumulitive counts based on dates. I am counting the date column of the new input lines with the following formula: =COUNTIF([Created Date]:[Created Date], TODAY() - @cell < 7) for Records added in the last 7 days and: =COUNTIFS([Created…
Hi Everyone, I am needing help with a formula. I need it to function as =if "Wet Paint" has check mark, change "Lane Designation" to Wet Paint. Thanks for the help in advance.
Assinged too.....how do i
How do I remove extra names in the drop list? In the early days I entered the wrong e-mail address, now I have two Heath with different e-mail addresses, I cant remove one of them.... Can someone help please ?
I have a task sheet with assigned dates. They are assigned to people. What I want to do is create a calendar showing who is assigned a task each day. However the calendar view is showing the ID number instead. How can I change this?
Trying to add a Sheet Data widget to a sight
Hi, I'm trying to create a Project management Dashboard but for some reason, when I click on "add a widget", I don't see the option to add a Sheet Data. Does anyone know why and how I can do this? THanks! Carine
Date linking or date formulas
Hello, I am not sure the best way to summarize what I am asking in to a search string so thought I would just ask the community. So right now I have a very dynamic production schedule, since we are a new company and still learning / growing we constantly update our production schedule (sometimes daily). My question is, if…
Is it possible to set due dates based on a formula?
Hello, I've imported an Excel sheet and my formulas aren't working. I'd like to automate due dates where the duration may change based on a numerical figure. For example, if there are 10 items to move, it will take 2 days for each of 4 tasks, but 100 items to move will take 5 days for each of 4 tasks. I've been playing…