-
Creating a calendar that is populated by dates on other sheets
Good day, Right now, we have several events happening in different cities on different days. For each event, we have a separate smart sheet, with individual planning tasks. but we want to have a combined calendar with just the dates of the actual event. I thought that I could do this by linking to the specific cell with…
-
index/match help
Please refer to the attached image. I would like to create a formula to display just the "Preliminary" cost for "Atlanta - Cumming" on a separate sheet using the index/match formula but keep getting an error. Can anyone help with this? I am open to using another function as well.
-
Repeat reminder on single task
Hi Has anyone used the new workflow to set up a daily reminder on a single task (row) until it is completed? I dont want to use % complete or date triggers just literally a daily reminder on a single tasks that is due to be completed with a daily reminder until completed. I have tried a few combos but not able to find a…
-
Multiple checkboxes
Hi there! I have two columns, for the sake of this example we can call them A and B. I would like to create a formula so that if A and B are both checked off, it will show the text "Sent" but if only A is checked the text will say "Reviewing". If neither checkboxes are marked I would like the text to read "Pending". Can…
-
Task list option for each project
Hello everyone, I'm looking for a way to add projects (color project lines) in one sheet. In the solution center, there is a project category and in it there is a task list option for each project. In this option specifically, I wish I could put as many projects as I want. Do you know a way to get there ?
-
Calculate End Date from "Start Date Plus Number of Days (calculated and rounded up via formula)"
Hello Community! I'm trying to calculate End dates based off of a hard Start date, and adding a number of Days that I have listed in another cell. The number of Days is calculated via formula, from one cell that lists Project hours (which I manually input) and each project is assigned to a crew, which have different…
-
Need to create chart with dates
Hi, How to create a pie chart(or any graph) with dates? I'd like to put a chart on the dashboard to show in which release these retirements are happening. I have a report that's pulling all retirement dates, but when I go to create the chart it says "Invalid Data, you must you numeric data". Please let me know what my…
-
Looking for a template option
Hello - I currently work with a spreadsheet that has multiple TABS - I am looking to move that spreadsheet over to Smartsheets and I was hoping someone could offer a template I could use. I have 6 different TABs - each tab has about 30 columns and 20 rows. (It is a multi-layered event planning checklist of sorts) Any help…
-
I need to restrict access to a web form to only a specific group, can I do that?
I am using Smartsheet as a project list and a web form as a work request system. I need to restrict access to the web form so only spefic people can file a request. is that possible?
-
Resource Forecasting
Here's what I want to be able to do for resource management. Is there a workaround to accomplish this? * Assign individual resources (they are not licensed users) to a team\group. Assigning tasks to multiple individuals does not work for me. * Each individual has default work hours. E.g. 8 hrs. It can be modified if needed…