-
Community Link in Help Menu Gone?
Hi all, My memory may be failing, but didn't the Help icon used to have several entries including a direct link to the Community Forum? Today when I clicked the ? icon, there are only two links: Help & Learning and Show Help Tips. Not a big deal, but that's one more step to get to the wealth of knowledge that the forum…
-
Task sheet check off box
When I try to check the done box in my task sheet it takes me to the edit page and I have to check it from there. This only happens when Im on my smart phone. From my computer I can check the box with out it going into my edit page. Is this supposed to happen? Can I change it?
-
Contact list and look up table
Hi, I am trying to set up automated alert to an area manager that is associated with certain stores. (Several Stores and several managers) This information is driven by forms and the only information that is chosen ( for this part) is the store name. I have managed to create tables and formulas that then auto populate the…
-
Can Viewers hide or filter columns that don't pertain to them?
My team has a spreadsheet that is shared internally (editing access) and externally (viewing access only). For the external partners that use the sheet with viewing access only, is there a way for them to hide or filter to the columns that pertain to them? They need to see all of the rows, but not all of the columns.…
-
Clear cell data based on dropdown selection
HI, I need to clear a date in a cell when a dropdown list selection is set to completed. This will then in turn remove the notifications from appearing and removed the conditional formatting used a visual tool. Ive tested an IF statement on the date cell, by adding the IF statement, adding the date and then selecting the…
-
Sights separator lines
Hi All! Could someone tell me how to add kind of separator line like this one? It is sight from smartsheet's template. It is fully interactive, so if I want make it wider, it is enough to drag the corner of this field. I tried to add a picture of a line from an icon, but it does not expand its width.
-
Transfer exet document to smart
Hi, I have to transfer excel doc. to Smart. Never work with Smarrsheet. I do not know how to transfer taps and all formula they have, they also all link to each other.
-
Multiple references
New to formulas and need some assistance please. I need to calculate the sum of a column if a check box in another column is checked and between a certain time frame and for certain assigned employees All i have been able to do is sum the check boxes within a time frame =COUNTIF({Deal Tracker - Acq Range 1}, AND(@cell >=…
-
FS date calculation issue
I have the following calculated task dates in a gantt chart: Task no. Duration Early start Early Finish Dependency 22 60d 1-Feb-2021 23-Apr-2021 23 60d 29-Jan-2024 19-Apr-2024 22FS+720d (See attached screenshot) Task #23 is supposed to start 720d after #22 has finished. But if you manually check the number of days between…
-
Summing up everyday new entry value into a different smart sheet
Hi, Can anyone give me some idea on Summing up across multiple smart sheets new entry value in separate smart sheet please. I can sum up specific cell values or range but i am looking for sum of daily entered values of same column from different sheets.
