-
Saving over other entries
I know SS will tell me when another user is viewing the tab, and it will tell me when they make changes so I can refresh. The challenges we're facing are: there's a good 30-45 seconds before SS tells me that someone is viewing the tab. That's plenty of time for them to get in, make a change, save it, and have me save what…
-
Enhancement Request: Filter for attachments
When viewing the attachments attached at the sheet or workspace level, it would be useful to filter for ONLY the attachments at that level. In the screenshot below, all Row attachments are visible, but I'm only interested (for this search) in the ones that are attached to the sheet. Similar functionality already exists for…
-
VLOOKUP, ISNA, IF Statement
Hi! I would like to know is this kind of formula available in smartsheet? =IF(ISNA(VLOOKUP(C2;I:I;1;FALSE));"NO";"YES") In short- If there is the same name in other collumn mark YES Thnak you!
-
Find the Max and Min value in a column
Hi, I have a sheet with a single column that has a large range of numbers. I would like to use conditional formatting to highlight the highest number and the lowest number within this column so its easy to see when viewing the sheet. I can use the functions Max() and Min() to find the highest and lowest values, but these…
-
Newbie please help - is this possible
Hi there I'm new to smartsheet and I'm wondering if the following is possible... I'd like to have a template waiting in smartsheet. I'd like to setup a Google form, when its populated, it would automatically be forwarded to smartsheet, as it arrives a new sheet is created based on the Template I created previously. I would…
-
Continous Merge (Real-Time)
Hi everyone, I am new to Smarthsheet, and I just figured out how to merge a Smartsheet with a Google Doc and automatically send it out in an email. Do you know if it is possible to do this in real time and not as a semi-batch process? Once a new smartsheet row is added I want it to automatically merge and send via email if…
-
LOOKUP function - I cannot find any info on how it is supposed to work
Hi, I have read some threads but I am still not clear on how LOOKUP is supposed to work. I know it cannot function across sheets. But please can someone provide the syntax and basic data? Thanks, Ele
-
Critical Path not working
The critical path on my schedule is not working, is there a report I can get from smartsheets to see what is porssibly going wrong? or Tips on what to do?? Much Appreciated! -Marisela
-
Greater than less than
Im attempting to make something that AUTOMATICALLY creates a way to change a percentage... our table goes like so.. 45% and up is 8% on another line anything between 44-41% is now 6% and 39% to 35% is 4% anythign less than 34% is 0% .. This is my equasion I think im on the right track but it does not give me the right…
-
Including just the latest comments
I would like to be able to send project tasks out to folks, but only include the last comment or comments limited to a certain date range. As it is currently designed, it all or nothing. I 'd like to be able to have a status meeting... then post my updates as comments to the applicable lines and then select those lines and…
