-
Background auto-refresh a sheet as frequently as every minute.
This might be my first real contribution to this community, but I think I have had a breakthrough with respect to background auto refreshing a sheet. I've seen the common solution of utilizing a workflow to trigger a daily update of a date column, but the challenge has always been that you are obviously limited in how…
-
Can someone please help me with SUMIF formula?
I am trying to use a formula that will add value in children cells when cells do not include an asterisk in front of the value. Basically, I am creating an invoice tracking spreadsheet and I want to be able to input expected monthly invoices (based on the contract) on the front end, but not have those values added to the…
-
REMOVE IF SLOT IS TAKE
Hello! Can we remove a time slot in the drop down on a specific date if it is taken. Below is an example. For example if someone Booked - Dec. 31, 2023 - 9:00AM - 9:20AM, can we automatically remove that from the drop down list since someone booked it? What are the ways?
-
Integrating non working holidays on another country
Hi fellow Smartsheeters, I encountered this problem after entering American holidays but our operations is affected by other suppliers in other countries like China. I think many of you have been affected by week long holidays like Chinese New Year week. Is there a way entering a certain countries holiday without making it…
-
Merged: Version History
This discussion has been merged.
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week:
-
Prevent Unintended Changes by Disabling Removal of Logic when renaming dropdown items
I was editing the value fields within the column. One of the dropdown answer choices was “New Request”. I simply just added a new word “New/Continuation Request”. When I added the new word, that’s when I found all of the associated logic removed. I never removed a field so in theory, the associated logic shouldn’t have…
-
Building a sheet to best populate dashboards
Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as red, yellow, green; sum of late tasks; sum of tasks in progress and on-track; sum of…
-
Merged: Predecessor links maintained when copying rows
This discussion has been merged.
-
Creating Charts from Reports
Hello, I am trying to create a chart from a report to have in my Dashboard. I have a report pulling my Engineer's Hours per project, and would like to create a way to sum all those up and create a graph showing this. Any help?