-
Configure availability for an individual. Apparently it exists, however I don't see this option.
Some of our people work 5 days per week others only 1 or 2 days. How do I set availability for each team member? I found this link describing what I need, however I don’t see those menu items. See attachment. Which Smarsheet icon do I click for Settings > Account Settings > People? On the bottom left corner of my…
-
Automation to change a cell value
Hello - I am trying to use an automation to change a cell value. I was originally triggering the change with a cell populated by a formula pointing to a cell with a cell link from another sheet, which I understand won't work. Is there a workaround for this? More detail: I am using smartsheet for headcount tracking in my…
-
Row sorting doesn't work as expected
I have a sheet with a column called Category. This is a drop-down column with options starting with A, B, C, G, L, PL, PP, and S. The items are ordered that way. When I sort the rows using that column, the result is A, C, G, L, PL, PP, S, and B. I have checked for strange characters and the order of the drop-down items and…
-
How to move specific rows without a helper column
I can't add another column to the main sheet to track which lines have already been moved, but I need to move select lines from four sheets to one other sheet. I have a workflow in place that is moving all of the lines that fit the description, but this is causing duplicates on the destination sheet. Using a report is not…
-
Is there a way to remove attachments from multiple rows at the same time?
I have a few sheets I am trying to clean up with attachments saved to each row/entry. Is there a way I can select multiple attachments from multiple rows at the same time to remove them? (Without removing the row all together) Thanks!
-
Identify Time Zone
Hi; I have a sheet that users captures information in, I have a column that records the modified date time, so the column is type of modified. Example Sheet1: Descrption , value , ModifiedDate abc , 123, 2024-01-01 10:50 <--- date time shown in Sheet ex GMT+2 Example Sheet2: Item Name , Value, ModifiedDate abc , 123,…
-
Shared sheet filter
Hi all, quick question regarding a shared filter on a sheet! We have a sheet that five people use to track certain information, so they'll be in there usually at the various times and sometimes at the same time saving data. The shared filter I created will help them see just the rows they're assigned to… If one person has…
-
Why am I receiving a microsoft sign in message sometimes?
I have embedded a MS Word document onto my dashboard. I own the document and the dashboard. Originally, the document displayed. Then as the day went on, a message displayed indicating I needed to sign in to Microsoft 365 to view the file. I clicked the sign in button, a window opened, but the file still did not display.…
-
Why this error showing ?
-
Removing an owner
We have a couple sheets/forms that have two owners. The one created it and then they gave another ownership as well. We need to remove the original owner, if we do so, will that affect anything that was created? OR is there a way to have the emails that go out to not have the original owners name attached to them? I wasn't…
