-
Overwriting lines
We are currently having issues with lines being overwritten when more than one team member is entering information into a sheet at the same time. Anyone else experiencing these issues?
-
Reassigning tasks in bulk to a New Resource
Hi, I have assigned multiple tasks to Jane, but I a new person is now taking over all of Jane's tasks. So is there a way I can bulk assign all the tasks and the sheets to the new person? Thank you!
-
Permissions to edit cells
Hello all. I have several work flow sheets, in which collaborators have to change the status of the tasks, but not all collaborators could change any status. The question is possible edit permissions on cells to avoid that any user could change it? Thanks
-
When should we use reports?
When should we use reports? i see no need to use reports, I want to know is there any importanve of using reports?
-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Predecessor Issue
Is anyone else having issues with the predecessors in SmartSheet? Right now, I have several sheets that have predecessors that have a duration of 1d and are following the row above without a 'type' (finish to start, start to start, etc.). As you can see from the screenshot, it has row 1 ending on 1/21 and row 2 start on…
-
Match Statement with Multiple Sheets
Hi, Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below: =IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO") I have another sheet…
-
Merging Formulas
Help! I need to create a formula to display a Budget amount for a particular team. The Team column is a Count Column, while the Budget column would be a sum. Can i do this? (eg: i want to know the budget # associated with a function lead and have that budget add it's self up) Essentially, we have multiple functions within…
-
Formula Function - SMALL for dates with duplicates (ERROR)
Hi, I'm currently using a formula to INDEX my sheet and pick up the smallest date in a column, and then display the 4 smallest (or soonest) dates in that column to pull into my dashboard. The formula is as follows: =INDEX([Project Name]:[Status], MATCH(SMALL([Next Milestone Date]:[Next Milestone Date], 2), [Next Milestone…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
