-
Feed line from one sheet into another multiple times, assigning a different task to each new line
Hello! I have a master sheet where I keep track of all of our companies' giveaways we offer. It has a lot of checkbox columns to identify which tasks have been done and which have not. Currently I have automated reminders set up that send me an email to tell me something needs done. However, that A LOT of emails, and I…
-
How can i use IF, AND in a date formuls?
I currently have a formula that looks at a column called "Week #" and takes the entry and converts it to a date that represents the first monday of the corresponding week. This helps me plan work a number of weeks out. the problem is that as i get towards the end of the year, i need the date produced to show the week for…
-
Recreating the Countermeasure and Task Spreadsheet
I am having problems recreating this sheet where multiple users (without logins) can update their project notes weekly on any progress made. I want it to associate the Countermeasure - Project - Task. I want to tie it to a A3 Dashboard (for each project showing the amount of task/ projects completed, inprogress, etc.
-
AI Text and Summaries Column Formula
Hey All, I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are like me, I'm sure you are all using and loving the AI feature! One thing that has been cumbersome about it has been that in…
-
How do I use AND within Join Collect?
Im trying to collect and Join names of vendors where the delivery date is greater than or equal to one cell and less than or equal to another cell. i just cant seem to get the syntax right. Below is my current formula. Am i using the AND formula incorrectly? =JOIN(COLLECT({Glass Orders Range 1}, {Glass Orders Range 2},…
-
Formulas that were working are now not pulling in data after connecting source sheet to a DataTable
Here is my set up: Datatable that contains all actual charges for our company's projects Project "actual charges" sheet that connects to this datatable and pulls in data based on a project ID Several other project sheets that link via formula to the project "actual charges" sheet Prior to implementing the datatable, there…
-
Question on Forms
Good afternoon. I have a question for you. I am using Forms for my spreadsheet. I have 7 days beginning with Monday. I wanted to do different sheets for each day. This is so the user would not be confused. Each day is placed on a separate row, Is it possible to have the forms Mon-Sunday show on the same row? In other…
-
Is there a way to create a column that re-numbers automatically when rows are moved around?
I feel silly that I cannot seem to figure this out. Is there a way that a column can contain a number that updates automatically when rows are moved around? For example, if the rows are numbered 1, 2, and 3 - in order, and then I move row 3 in between rows 1 and 2, I want that cell to automatically update to become 2 and…
-
Monthly Count of Request Types
Good day, I am looking for a formula that can count the number requests of a certain type in the current month. For example the two columns I have are "Request Type" and "Request Created." The request created is the standard request created column built into Smartsheet. The "Request Type" column has multiples types say…
-
How tu sum durations of the task and it's predecessors.
Hi All, Is it possible to sum in Smartsheet the the duration of the task with but also with the durations of the predecessors of this task? for example task 3 lasts 3 days but it's predecessors are task 1 (4 days) and task 2 (5 days) (typical FS). so the duration of the task would be 3+4+5 (in some helping column). Thanks…