-
Conditional Funding
Would there be a way for me to add my second and third columns based upon the conditional formatting of the rows? the conditional funding only depends upon one variable.
-
Deleting a Report Item also deletes it in the Sheet?
I came across an interesting interaction today while editing a report. When I went to delete an item off of the report, the item itself also disappeared from the sheet that it was associated with. Is there any way I can retrieve that information and have it back on the sheet but not the report?
-
Hyperlinks to other sheets not showing
Hi, anyone experienced this? I have a master sheet with a column that contains all the hyperlinks to the subsidiary sheets. The links have gone overnight! Cell history shows they were updated by a cell link user, but the cells aren't linked.... The link still exists if you double click on a cell it shows the correct link…
-
Breakthrough...
After 6 months of internal debate and resistance SS is finally taking hold, colleagues want to get involved and more process is heading the SS way...I feel like running round the park naked!! Thanks Smartsheet
-
create dashboard
Hi sir I am new user o smartsheet and i have a quiry .. please help me
-
Publishing Gantt Chart
We have a Gantt Chart, we have many columns for various items and the standard Start/Finish/%Complete....... We don't want to share the sheet with a lot of people they don't need all those extra columns, we really just want to show them the Primary/Task Column and the the Gantt Timeline that is it. Is there a way to…
-
Calendar calculation (possible bug)
I am having difficulty with a calendar calculation that I use to calculate planned completion %. When dates have more than 30 days or when a non-working (holiday) is part of the month, the formula is not working as intended. Below is the formula in the planned % complete column: =IF([Planned Finish]4 = TODAY(), 1,…
-
Evaluating Chidren
I want the value of a cell to highlight if all the date fields (Children) and the date field of the parent cell, in a different column, are NOT BLANK. How can I evaluate children to see if any are not blank? I tried to put the Children() function inside of the Not(IsBlank()) function, but it threw an error..? Any Ideas?
-
How do i restore sheets to the correct workspace?
We recently lost our admin and we had to transfer owner to a new admin. it worked great for most of the workspaces. however, we have 87 sheets in a new folder called "Transferred from oldadmin@email.com". and the folders that used to have sheets now appear empty to all users who still look like they have access to the…
-
Countif a value AND Completed Date not Blank
Struggling with the right equation. Completed Date Column has no end range (rows can continue to be added at anytime via a form). Size Column has many different sizes 32, 40, 50, 60, 72, 80, 100, 106 that can be in the column. In additional columns I have a column for each size. I want to count how many size 32 I have IF…
