-
Automatic Quarterly Reminders?
Hi there! I am building a database to monitor multiple cashflows and am tying to figure out the best way to set up an automatic reminder for the person responsible for each cashflow to update financial information on a quarterly basis. I was thinking of creating reminder date columns (and hiding them) for each quarter. Is…
-
IF statements
So I have this formula for the 'Assigned to' column: =IF([Updated by]1 = "jillian@email.com", "alex@email.com", "mark@email.com") where if someone updates and saves a row, if the email of the person who updated matches the one in the IF, it will assign to the first employee, otherwise it's assigned to a different employee.…
-
Linking smartsheet cells to Google sheets
Can we link a particular set of cells or values from Smartsheet to a Google sheet? If yes, then how can we do it?
-
Sprint Name field
How can I get the Sprint name field to pull from Jira to Smartsheets? The Sprint field is not showing up as a field in the Jira + Smartsheets connector for me to sync.
-
Automate Child Row Based on Parent Row
Hello SS community. I am curious to know if there is a way to update a child row based on a parent row. My real world scenario is as follows. I move children rows physically on the page into one of 6 sections contained by parent rows. When I move a row into the 'Completed' section, I would like the status column to change…
-
one time change cell
Hi, There I would like to know if It is possible to freeze a column one's validation is given to make sure no more modification can be done. Thank you,
-
Resource Allocation
So we have some re-occuring projects sheets that are used like check list. example: * Board Meeting* Put out Name Tags * Confirm Tech Times * Check AV Equipment And a lot of time they are all assigned to one person. We know that we can assign the value to these tasks a percent that is low, but is there a way to set…
-
Time Tracking
I have been tasked with creating a time-tracking sheet to hopefully avoid looking elsewhere. We have various areas that work on the same project, so we need to track their work. I have started by creating a parent row (listing the name of the project) followed by the various columns of data we need to track. However - and…
-
Task Duration - Partial day at beginning of period, not the end
Hi, I notice when you add a half day duration to a task, it places the half day at the end of the period, for example a start date of 13/11/17 (Monday) with a duration of 2.5 days will result in the half day being on the Wednesday. Is it possible to make the half day on the Monday and the full day on the Wednesday? I'm…
-
Setting intermittent dates for a single task
I am just getting started with Smartsheets. So far, I am really liking the ease of set up and functionality. One issue I am struggling with is how to set up intermittent dates for a single task. For example, I have a single task where I want to set a date for every other Friday to meet with the client. I don't want to have…
