-
Move the Deleted function to another section
Please move the Delete function away from the Edit function for a row in a worksheet. THIS CAUSES A LOT OF ISSUES JUST BY BEING NEAR EACH OTHER!!! Locking rows isn't an option, unless you can tell me if I can lock only certain columns.
-
When using the Workflow for deletions
When using the workflow "Alert someone when a row is deleted," it would be nice if we could have some of the information from that row in the message. For instance, I have an alert setup for deletions, however, it isn't able to capture the Request Title or ID number, because those fields are deleted when a row is deleted.…
-
How to Phrase a Question for the AI or Write the Formula for Myself for Grouping Data
Hello, I would like to see if anyone can help me parse entries across different columns. What I have in my SS is a list of registration numbers in Column A and departmental associations in Column B. I would like to count how many different registration numbers appear in Column A and then group them by their departments in…
-
How to create Icons into a Dashboard
Wondering if anyone knows how to include a link on a Dashboard to other Smartsheet grids/ reports with icons (not just a list)- here's an example :
-
Fix PDF print function with Latin Extended letters
After a helpless few months of knocking on Smartsheet support doors, our company finally got the answer, to why our texts randomly change from set conditions in PDF forms (font, font size, font weight), to a different text. As it seems, if the text in a cell has any Latin Extended letters (ą, č, ę, ė, į, š, ų....), it will…
-
In Timeline View, is it possible to show Baseline vs Actual?
I know in gantt view you can see a line for baseline below the bar for actual. Is there a way in the Timeline view to display bars for baseline dates along with actuals? I know you can show the actual baseline dates in text, but I'd like to have them displayed as bars. Has anyone figured out a way to do that?
-
Pull most recent date from another sheet based on two criteria
I am trying to pull the most recent date that a recurring job. I have the facility where the work was conducted, the last day of the job and the job category on the other sheet. I need the category section of the formula to look for a word contained within the text.
-
% of check boxes
I am trying to make the row 20 box thats selected to display a % of the check boxes in rows 2-19 that are selected. I have tried a couple formulas none work. =COUNTIF([Complete]2:[Complete]19, 1) / COUNT([Complete]2:[Complete]19) =COUNTIF([Complete]2:[Complete]19, "true") / COUNT([Complete]2:[Complete]19)
-
How Can I Set Up Hourly Archiving Without Breaking Datamesh?
Hi there, I need help setting up an hourly automation for our Department Calendar sheet. Here’s the situation: This sheet is connected to the Master Events sheet via Datamesh. When an entry is cancelled, Datamesh needs to trigger on the master sheet before the entry is archived from this sheet. If the entry is archived…
-
Adding a secondary sheet into the equation
HI! I have the below formula which is pulling info from a sheet and giving me a percentage based on the p/f in a column. I have a third sheet that is the same info as the p/f sheet this is based on (technically the archive of this one) that i would like to add in as included in the percentage. So basically my formula needs…